Post reply

Is there a way to convert Japanese characters stored in ISO-8859-1 (in SQL Server column) to UTF-8?

  • April 10, 2009 at 4:26 am

    #100613

    We have an 3rd party .asp application that is saving Japanese/Chinese characters into our SQL Server 2005 database in ISO-8859-1 format.

    Within the .asp application, the characters display correctly - but when I look at the data using SQL Server Management Studio, the data looks garbled -

    I'm wondering if there is a way to take a string (it's nvarchar) stored in SQL Server in ISO-8859-1 - and convert it to UTF-8 within T-SQL -

    Has anyone run into a similar problem?

    Thanks,

    Michelle

  • April 10, 2009 at 3:16 pm

    #975974

    If the machine were you are running SQL Server Management Studio does not have the needed fonts installed to view these characters, the data will be garbabled"

    Do these appear correctly ?

    French Français

    Japanese ???

    Russian ???????

    Portuguese Portugués

    Greek ????????

    If you are missing fonts, contact the windows admins or desktop support.

    SQL = Scarcely Qualifies as a Language

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

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