Prev: how to replace in sql
Next: default directory change for full text search
From: bob123 on 13 Jun 2010 04:06
OK Erland
Thanks for your explanations

"Erland Sommarskog" <esquel(a)sommarskog.se> a �crit dans le message de news:
Xns9D95E916639FCYazorman(a)127.0.0.1...
> bob123 (bob123(a)gmail.com) writes:
>> so what is Latin1 or CP1 ?
>
> A collation designator consists of several parts. For instance,
> Finnish_Swedish_100_CS_AS_KS_WS.
>
> Finnish_Swedish means that the collation is based on the rules and
> Finnish and Swedish.
>
> 100 means that the collation was added in SQL 2008. There is also a
> Finnish_Swedish collation without a number that first appeared in
> SQL 2000. The 100 collations incorporate more character from Unicode
> and may also incorporate recent changes in the languages. For instance,
> may be there will be a Swedish_110 collation later on where V and W
> sorts as separate characters, since the Swedish Academy separated them
> in the most recent edition of their dictionary.
>
> The CS, AS, KS and WS parts reflects whether the collation is sensitive
> to differences in case, accents, katakana/hiragana and singlewidth/double-
> width respectively. (The latter two mainly relates to East-Asian
> languages.)
>
> A number of collations have SQL in the name. They are SQL collations,
> and they are legacy collations from SQL 7 and earlier. They are different
> from the Windows collation in that they have different sorting rules
> for varchar and nvarchar.
>
> The Latin1_General is like Finnish_Swedish describes for which languages
> it is applicable. Latin1_General applies to a larger number of
> languages for which a common set of rules can be used. The four most
> significant in this group are English, Dutch, German and Italian.
>
> The 1 in Latin1 comes from that in the 1980s a suite of 8-bit character
> sets were defined by ISO whereof Latin1 covered Westernn European
> languages, Latin2 covered Eastern Europe and so on.
>
> The CP1 is presumably short for CP1252 which is the code page for
> Latin-1 in Windows. In Windows there are a number of code pages
> that each covers an 8-bit character set, and applications that work
> with 8-bit character data will work with the ANSI code page in
> windows - unless it's a console application that runs from the command-
> line window in which case it will use the OEM code page.
>
> If you are active in an English-speaking country I would recommend that
> you use Latin1_General_CI_AS. There are some nasty gotchas with SQL
> collations, so there is all reason to avoid them.
>
>> anything begining with N' is UNICODE ?
>
> Yes.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>


First  |  Prev  | 
Pages: 1 2
Prev: how to replace in sql
Next: default directory change for full text search