Translating Unicode to its native Japanese Language

  • 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

  • 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.

  • 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