Hi

UTF-8 is an encodibng scheme for unicode data, and sqlserver 2k doesnt store
data in this format . Now, from what I understand, ss2k uses ucs-2 (allows
for encoding of 65536 different code points. And utilising unicode 2.0
standard, not 3.0.

see: intlfeaturesinsqlserver2000.asp on MSDN.



-----Original Message-----
From: Prasad Sombhatta [mailto:prasad.[Email Address Removed] Thursday, 27 June 2002 10:52 PM
To: [Email Address Removed] SQL Server 2000 --UTF-8 Compliance


Hi All,

I would like to know whether SQL Server 2000 is UTF-8 Compliant? Right now
we are using it for US purpose but would like to use SQL Server 2000 for
Chinese, Japanese and Korean character strings as well. I would like to know
if this is possible, what are the settings that I need to do?

Thanks
Prasad Sombhatta




MS Sql Server LazyDBA home page