Re: UTF-8 Coding of MSSQL 2005 DB

See the following artciles:

Description of storing UTF-8 data in SQL Server (the article points to SQL 7/2000, but 2005 still uses UCS-2)
http://support.microsoft.com/kb/232580

UTF8 String User-Defined Data Type
http://msdn2.microsoft.com/en-us/library/ms160893.aspx

International Features in Microsoft SQL Server 2005
http://msdn2.microsoft.com/en-us/library/bb330962.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

.

Relevant Pages

  • Re: utf-8
    ... SQL Server stores Unicode data in UCS-2 not UTF-8, ... Storing UTF-8 Data in SQL Server ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.programming)
  • Re: UTF-8 Coding of MSSQL 2005 DB
    ... Description of storing UTF-8 data in SQL Server ... International Features in Microsoft SQL Server 2005 ... mean, the scripts that we are using in perl are writing to the DB in UTF8, and the displayed information in the webapp is returning properly, but when you look at the data in the table, it is displayed incorrectly. ...
    (comp.databases.ms-sqlserver)
  • Re: The Register interview Nigel Brown
    ... database backend, SQL Server 2000, only supports UCS-2 ... What is the difference between UCS-2 and UTF-16? ... Jonathan ...
    (borland.public.delphi.non-technical)