• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

SQL Server 2005 support utf-16

Does SQL Server 2005 enterprise edition support utf-16? If yes, than how do I know from current install of SQL Server that it has support for utf-16.
0
jamesBond008
Asked:
jamesBond008
  • 2
1 Solution
 
reb73Commented:
SQL Server 2000 onwards ONLY supports UTF16 natively in terms of data storage in the backend.

0
 
jamesBond008Author Commented:
Hi reb73, Can you explain this in detail or send me a link. Pardon my ignorance. We are looking if our sql server can store chinese or japenese data.
0
 
reb73Commented:
Yes, SQL Server can store Far-East asian language characters using the unicode datatypes (nchar, nvarchar, ntext etc) and collations. These datatypes use UTF-16 /double-byte little endian format natively.

UTF-16 is the standard for Microsoft and Windows operating system in general

http://msdn.microsoft.com/en-us/library/bb330962.aspx#intlftrql2005_topic2

0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now