Am I UNICODE ?
in [Server Configuration]
|
From: bob123 on 10 Jun 2010 03:40 Hi, On my SQL Server 2008 my collation is SQL_Latin1_CP1_CI_AS am I unicode ? Thanks in advance
From: Uri Dimant on 10 Jun 2010 05:07 Hi Use NAVARCHAR(n) to be 'unicode' CREATE TABLE #tmp (c VARCHAR(20),c1 NVARCHAR(20)) INSERT INTO #tmp(c,c1) SELECT 'text in hebrew',N'text in hebrew' SELECT * FROM #tmp ---only second column shows the right value "bob123" <bob123(a)gmail.com> wrote in message news:4c109700$0$20493$426a74cc(a)news.free.fr... > Hi, > > On my SQL Server 2008 > my collation is SQL_Latin1_CP1_CI_AS > am I unicode ? > > Thanks in advance > >
From: Erland Sommarskog on 10 Jun 2010 16:42 bob123 (bob123(a)gmail.com) writes: > On my SQL Server 2008 > my collation is SQL_Latin1_CP1_CI_AS > am I unicode ? To use Unicode, you need to use the nchar/nvarchar/ntext data types. The server collation does not really matter in that regard. -- 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
From: bob123 on 12 Jun 2010 09:05 Thanks so what is Latin1 or CP1 ? anything begining with N' is UNICODE ? "Erland Sommarskog" <esquel(a)sommarskog.se> a �crit dans le message de news: Xns9D93E704940A4Yazorman(a)127.0.0.1... > bob123 (bob123(a)gmail.com) writes: >> On my SQL Server 2008 >> my collation is SQL_Latin1_CP1_CI_AS >> am I unicode ? > > To use Unicode, you need to use the nchar/nvarchar/ntext data types. > The server collation does not really matter in that regard. > > -- > 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 >
From: Erland Sommarskog on 12 Jun 2010 16:54 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
|
Next
|
Last
Pages: 1 2 Prev: how to replace in sql Next: default directory change for full text search |