Afficher un message
Vieux 26/03/2008, 16h30   #3
Shawn Beasley
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: UTF-8 Coding of MSSQL 2005 DB

Hi Plamen,

Thanks for your answer.
> 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


I found this one, but could not really understand the meat of the mater.

> 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.aspxB


Basically, there is no native UTF-8 storage then in MSSQL, am I right? I
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. Does that seem right?

I am speaking of storing German charachters like "äöüß"

--shawn


  Réponse avec citation
 
Page generated in 0,04575 seconds with 9 queries