Re: utf-8

From: Gert E.R. Drapers (GertD_at_SQLDevNet)
Date: 02/25/05


Date: Fri, 25 Feb 2005 16:11:48 +0100

SQL Server stores Unicode data in UCS-2 not UTF-8, please read
http://msdn.microsoft.com/library/default.asp?url=/library/techart/intlfeaturesinsqlserver2000.htm
and http://support.microsoft.com/default.aspx?scid=KB;EN-US;232580 INF:
Storing UTF-8 Data in SQL Server (232580)

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"JD" <jdnews@dalys.us> wrote in message
news:%23WyOZEoGFHA.2156@TK2MSFTNGP09.phx.gbl...
> And that is it, seems pretty straightforward, thanks.
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:%23HgP0XkGFHA.2384@TK2MSFTNGP10.phx.gbl...
>> JD
>> Define a column as NVARCHAR()/NCHAR()
>>
>>
>>
>> "JD" <jdnews@dalys.us> wrote in message
>> news:eFm$fdjGFHA.2412@TK2MSFTNGP14.phx.gbl...
>>> I am working on a database that will be set up for multiple languages,
>>> the
>>> data will be set up as utf-8 and I want to store this in a sql server
>>> 2000
>>> database. I was wondering how do you set this up in sqlserver and so on.
>> Any
>>> help would be appreciated. Thanks.
>>>
>>> --
>>> J. D
>>>
>>>
>>
>>
>
>



Relevant Pages

  • Re: utf8-db
    ... Vyas, MVP ... But SQL Server stores Unicode data as UCS-2 not as UTF-8 ... > Vyas, MVP ...
    (microsoft.public.sqlserver.server)
  • Re: utf8-db
    ... But SQL Server stores Unicode data as UCS-2 not as UTF-8 ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.sqlserver.server)
  • 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: 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) ...
    (comp.databases.ms-sqlserver)