MSSQL, varchar data to nvarchar data
Posted
by Øyvind
on Stack Overflow
See other posts from Stack Overflow
or by Øyvind
Published on 2010-05-10T12:19:17Z
Indexed on
2010/05/10
12:24 UTC
Read the original article
Hit count: 309
I've got a database with collation Danish_Norwegian_CS_AS and lots of varchar columns. I'd like to convert all this data to unicode, but haven't found a way to convert this data yet. If I've understood correctly, the encoding used is UCS-2 little endian.
For example I've got a column containing 'PÃ¥l-Trygve' which is easily converted with C# to 'Pål-Trygve' using Encoding.Default.GetString(Encoding.UTF8.GetBytes("PÃ¥l-Trygve"));
Is there a way to do this conversion in the microsoft SQL client?
© Stack Overflow or respective owner