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

Question

question

Mandar Alawani asked Apr 12, '10

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-2005 xml datatypes editions

10 |1200

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

Answer 1 · 2010-04-12T08:25:06Z

Matt Whitfield answered Apr 12, '10

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

10 |1200

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

Mandar Alawani · Apr 12, 2010 at 08:29 AM

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 ·

Matt Whitfield ♦♦ · Apr 12, 2010 at 08:35 AM

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 ·

Mandar Alawani · Apr 12, 2010 at 08:59 AM

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 ·

question