Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Codepage Conversion Question

Author  Topic  rdugre Starting Member 32 Posts Posted - 2004-10-11 : 14:09:23 I have an ASP.NET application where I allow the user to select the character set and codepage of their data for their account. Their database uses nvarchar fields to store the double-byte characters required by some languages. Everything appears to be working properly when the user tries to store Korean characters with Unicode as their codepage, but when they select Korean, they experience some display problems in the browser when the data comes from the database. So, this leads to my question. Is there a way within T-SQL to convert data that was stored with the Korean codepage to the same data (characters) with a Unicode codepage? I only ask because my user has a lot of data stored in SQL with a Korean codepage set, and I obviously don't want to make them re-enter anything, if possible. Any pointers in the right direction would be appreciated.