SQL Server 2005 support utf-16

Posted on 2009-04-30
Last Modified: 2012-05-06
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.
Question by:jamesBond008
    LVL 25

    Expert Comment

    SQL Server 2000 onwards ONLY supports UTF16 natively in terms of data storage in the backend.


    Author Comment

    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.
    LVL 25

    Accepted Solution

    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


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now