تغییر زبان و تنظیمات collation بعد از نصب sql server 2008

[ja.softeng]

خروجی دستور معرفی شده به شرح زیر است. لطفا اگر امکان دارد توضیح دهید چرا اینقدر برای زبان فارسی Collation وجود داره

name description
--------------------------------------------------------------------------------------------------------------------------------
Persian_100_BIN Persian-100, binary sort
Persian_100_BIN2 Persian-100, binary code point comparison sort
Persian_100_CI_AI Persian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Persian_100_CI_AI_WS Persian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Persian_100_CI_AI_KS Persian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Persian_100_CI_AI_KS_WS Persian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Persian_100_CI_AS Persian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Persian_100_CI_AS_WS Persian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Persian_100_CI_AS_KS Persian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Persian_100_CI_AS_KS_WS Persian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive
Persian_100_CS_AI Persian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Persian_100_CS_AI_WS Persian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Persian_100_CS_AI_KS Persian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Persian_100_CS_AI_KS_WS Persian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Persian_100_CS_AS Persian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Persian_100_CS_AS_WS Persian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Persian_100_CS_AS_KS Persian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Persian_100_CS_AS_KS_WS Persian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive
Persian_100_CI_AI_SC Persian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters
Persian_100_CI_AI_WS_SC Persian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters
Persian_100_CI_AI_KS_SC Persian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters
Persian_100_CI_AI_KS_WS_SC Persian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters
Persian_100_CI_AS_SC Persian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters
Persian_100_CI_AS_WS_SC Persian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters
Persian_100_CI_AS_KS_SC Persian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters
Persian_100_CI_AS_KS_WS_SC Persian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters
Persian_100_CS_AI_SC Persian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters
Persian_100_CS_AI_WS_SC Persian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters
Persian_100_CS_AI_KS_SC Persian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters
Persian_100_CS_AI_KS_WS_SC Persian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters
Persian_100_CS_AS_SC Persian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters
Persian_100_CS_AS_WS_SC Persian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters
Persian_100_CS_AS_KS_SC Persian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters
Persian_100_CS_AS_KS_WS_SC Persian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters

درضمن جناب

ashkandehnavi

گزینه

Latin1_general_CP1256_CI_AS

را پیشنها کرده اند که در فارسی هم جواب میده. پس لیست بالا برای چیه؟

ممنون

سلام برای منم همین سوال پیش امده که چرا این همه Persian_100 وجود داره میشه یه نفر توضیح بده و هرکدوم به چه دردی میخوره..

برای منم این سوال بود
که یک فایل صوتی دیدم کلا جواب همه رو داده
https://nikamooz.com/what-is-collation-in-sql-server/