Post reply

Translating Unicode to its native Japanese Language

  • December 29, 2005 at 8:41 am

    #167559

    I have an issue I need to resolve with SQL Server 2000...

    I have a column of data type varchar which is currently storing unicode data...

    I need to translate that unicode data to its native Japanese language. Has anyone dealt with this problem before? Any help would be appreciated.

    Thanks,

    Dave

  • December 30, 2005 at 4:14 am

    #612098

    varchar or nvarchar?...only the latter can store unicode characters.  search here (and other reputable sites) for "sql + unicode + translate" or "sql + unicode + japanese".....others have come across this problem before.

    You may need to clarify 'where this conversion is to take place'...direct in some data tables, when displayed in some presentation layer, when reviewed in SQL-QA, etc?

     

    I don't have any glabalisation issues myself, so my experience is limited to the basic reports I've read here and elsewhere.

  • December 30, 2005 at 8:26 am

    #612148

    Thanks for your response. You are right about nvarchar, I found that a bit odd as well, but it would appear that the column is not even storing unicode! Its some form of character data. Thank you for responding and have a great new year.

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

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