Which is the best match for European + English

Question

Hi there,

I am developing for European languages ​​as well as for English, the string is stored as NVARCHAR in SQL Server 2005.

So, what is the best mapping to use, does this "Latin1_General_CI_AS" cover everything? there are variations, as well as Latin1_General_CP1_CI_AS, Latin1_General_BIN, Latin1_General_BIN2, etc.

Comments / suggestions are appreciated.

Relations DEE

Answer 1

For general-purpose sorting, “General Latin1” is probably the best choice for Western European and English.

, (, CP1) , 1252 ( CP1). , Latin1_General_CI_AS Latin1_General_CP1_CI_AS . , , Latin1_General_CP1_CI_AS . CI_AS, CS_AS CI_AI - , , / . CI, "a" == "A" AI, "á" == "â".

_BIN _BIN2 , . , , , . , , , . .

, , char, memo varchar. Unicode (nchar, nvarchar, nmemo), . Unicode , .