Re: UTF-8 Coding of MSSQL 2005 DB
- From: Shawn Beasley <shawn.beasley@xxxxxxxxxx>
- Date: Wed, 26 Mar 2008 15:30:52 +0100
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
.
- Follow-Ups:
- Re: UTF-8 Coding of MSSQL 2005 DB
- From: Erland Sommarskog
- Re: UTF-8 Coding of MSSQL 2005 DB
- From: Plamen Ratchev
- Re: UTF-8 Coding of MSSQL 2005 DB
- References:
- UTF-8 Coding of MSSQL 2005 DB
- From: Shawn Beasley
- Re: UTF-8 Coding of MSSQL 2005 DB
- From: Plamen Ratchev
- UTF-8 Coding of MSSQL 2005 DB
- Prev by Date: Re: UTF-8 Coding of MSSQL 2005 DB
- Next by Date: Re: call script from another script
- Previous by thread: Re: UTF-8 Coding of MSSQL 2005 DB
- Next by thread: Re: UTF-8 Coding of MSSQL 2005 DB
- Index(es):
Relevant Pages
|
