Post reply

Unicode in SQL Server

  • December 4, 2003 at 7:43 pm

    #160464

    How do I configure the SQLServer 2000 to use Unicode as its default code page? (i.e. varchar columns will be treated as the same as nvarchar columns)

    Which collation name is it?

    Thanks.

  • December 5, 2003 at 1:50 am

    #484755

    AFAIK only NCHAR, NVARCHAR and NTEXT can support unicode data.

    The collation is something different.

    You might want to read BOL Unicode data type -> Using unicode data

    Among other it states

    quote:

    All Unicode data uses the same Unicode code page. Collations do not control the code page used for Unicode columns, only attributes such as comparison rules and case sensitivity

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply