PHWinfo - Afficher un message - UTF-8 Coding of MSSQL 2005 DB

26/03/2008, 17h15

Basically if you store your data in BINARY or VARBINARY data type, SQL
Server could care less what encoding the data is. But then you can use it
only as storage, as ordering and string functions do not work properly.

SQL Server supports UTF-8 encoding for handling XML documents. You can
define a column of XML data type and use it for storing UTF-8 data in XML
format. See more here:
http://msdn2.microsoft.com/en-us/lib...ql2005_topic14

Also, the example for implementing UTF-8 user defined data type works fine
too:
http://msdn2.microsoft.com/en-us/library/ms160893.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

26/03/2008, 17h15	#4
Plamen Ratchev Messages: n/a Hébergeur:	Re: UTF-8 Coding of MSSQL 2005 DB Basically if you store your data in BINARY or VARBINARY data type, SQL Server could care less what encoding the data is. But then you can use it only as storage, as ordering and string functions do not work properly. SQL Server supports UTF-8 encoding for handling XML documents. You can define a column of XML data type and use it for storing UTF-8 data in XML format. See more here: http://msdn2.microsoft.com/en-us/lib...ql2005_topic14 Also, the example for implementing UTF-8 user defined data type works fine too: http://msdn2.microsoft.com/en-us/library/ms160893.aspx HTH, Plamen Ratchev http://www.SQLStudio.com