Post reply

Is sql server 2000 UTF-8 compatible?

  • April 10, 2007 at 3:56 pm

    #62904

    Hi,

    Is sql server 2000 UTF-8 compatible? if not how do we convert the SQL database to support UTF-8?

    As far as i know

    SQL Server 2000 use a different Unicode encoding (UCS-2) and do not recognize UTF-8 as valid character data.

    Currently these are the collations specified on my server

    Server Level Collation: SQL_Latin1_General_Cp1_CI_AS

    Database Collation: SQL_Latin1_General_Cp1_CI_AS

    Windows Collation: Latin1_General (Language used is English (United States))

    Any answers on this is really appreciated.

    Thanks in advance.

  • April 11, 2007 at 5:19 am

    #699734

    Hello,

    Below is the link from Microsoft which provides good information of what you are linking.

     

    http://msdn2.microsoft.com/en-us/library/aa902669(SQL.80).aspx

     

    Hope it helps.

    Thanks,

    Suresh

  • April 11, 2007 at 3:15 pm

    #699916

    No, it is only UCS-2 compatible. MSS 2005 has some UTF-16 features for collation and data manipulation but still only formally endorsed USC-2. If you want to load UTF-8 data into a MSS 2000 or 2005 database, it can be done only by converting it to UCS-2. If data falls outside the BMP (Basic Multilingual Plane), then you can convert it to UTF-16 and store it in MSS. But MSS itself only recognizes this data as 2 separate UCS-2 characters whereas UTF-16 recognizes it as a surrogate pair making up a supplementary character. As long as your UTF-8 application can recognize the surrogate pair and do a data conversion from UTF-16 to UTF-8 when it receives data from MSS 2000 or 2005, then your client app. can receive UTF-8 data from MSS.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply