transform UT8 to UCS-2

Question

Hi,

I have recently learned that sql server 2005 does not support UTF8:

http://stackoverflow.com/questions/3336992/utf8-problem-sql-server

I believe it supports UCS-2 though and look for a way to transform UTF8 to UCS-2 without loss of information if possible. Is it?

Any feedback would be very much welcome. Thanks!

Christian

PS: C# preferred (-:

Answer 1

It looks like you have a text file encoded in UTF-8 and you want to re-encode it to UCS-2. StreamReader and StreamWriter support encoding automatically; you supply an Encoding object in their constructors.

You should be able to:

1. Construct a StreamReader with Encoding.UTF8
2. Construct a StreamWriter with Encoding.Unicode
3. Read lines from the reader and write them to the writer