question

Mandar Alawani avatar image
Mandar Alawani asked

Procedure for installing / configuration SQL Server 2005 Standard Edition supporting UTF-16

Hi,

Sorry if I sound silly..but I dont have much knowledge about UTF-16 support in SQL Server 2005.

What is UTF-16 and its use in SQL Server? Is it the feature that stores and processes XML data type??

I need to find out the procedure for installing / configuration SQL Server 2005 Standard Edition supporting UTF-16.

As per my knowledge, SQL Server 2005 Standard Edition supports UTF-16 (XML Data type) by default. Hence, the normal setup process hold true, is it?

one of the reference links is :

http://www.windows-noob.com/forums/index.php?/topic/454-how-can-i-install-sql-server-2005-sp2-standard-edition-in-windows-server-2008/

can someone throw some light on it?

sql-server-2005xmldatatypeseditions
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Matt Whitfield avatar image
Matt Whitfield answered

You don't do anything special to enable unicode support. However, I don't believe that the unicode flavour supported by SQL Server is UTF-16, I think it's UCS-2. UCS-2 is older, and doesn't support surrogate pair characters. If all your unicode characters are in plane 0 (0x0000 -> 0xFFFF) then you shouldn't have any problems.

3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

i m sorry for my ignorance... does that mean, SQL Server 2005 SE does not support UTF-16 or it does not need to support it? also, is it poss to give an example for this?
0 Likes 0 ·
It doesn't support it completely - UCS-2 is like an older version of UTF-16. I'm not sure what you really want example wise?
0 Likes 0 ·
I wanted an example to just know whether I can save XML of format UTF-16 in SQL Server 2005 SE? Or what do you think is the best way to save XML data type in my scenario?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.