SQL2000 Collation Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Julie (anonymous_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 06:57:10 -0700

Use Unicode, nchar, nvarchar, ntext instead. Unicode is
language independant and will store any character you
want. The downside is it takes double the space.

Look up Unicode on BOL.

J

>-----Original Message-----
>How do I set the collation on SQL2000 so that I can store
characters from
>different countries on the same field inside a table?
>Another collation problem, I create a database with
collation
>'Chinese_Taiwan_Stroke_CI_AS' and then create a table
with collation
>'Chinese_PRC_Stroke_CI_AS'. I can only enter Traditional
Chinese but not the
>Simplified Chinese as I set on the table's collation. Why?
>Thanks a lot.
>Joe.
>
>
>.
>

Relevant Pages

  • Re: More elegant UTF-8 encoder
    ... Unicode as a sequence of bytes, store it into a sequence of bytes. ... Janusz Brzozowski's notion of derivatives of regular expression, ... which allows me to store the character ranges in their utf8toint encoded ...
    (comp.lang.c)
  • Re: Any forseeable disasters?
    ... >> Let's say you want to store a character of the Unicode ... > wchar_t is enough sufficient to store Unicode characters. ... A proper signature line consists of the four character sequence: ...
    (comp.lang.cpp)
  • Re: Collation settings
    ... but why would they want to change the default sort order? ... if you're not using Unicode, there will be small system-wide performance improvement in character operations - basically for free. ... Nor, for that matter, is there a collation SQL_Latin1_General_CP1_BIN, for some reason. ...
    (microsoft.public.sqlserver.server)
  • Re: varchar or nvarchar
    ... N stands for National character set. ... NCHAR and NTEXT are Unicode ... data types. ... They store each character as two bytes rather than one to ensure ...
    (microsoft.public.sqlserver.programming)
  • Re: varchar or nvarchar
    ... NTEXT are Unicode ... >data types. ... They store each character as two bytes ...
    (microsoft.public.sqlserver.programming)