Encoding problem

[Calvin Lai]

If my data in SQL server was stored from a web application with
requestEncoding set as iso8859-1. And now I want to change the data encoding
to big5, (or anything else), how could I do that? Thanks for all advice and
input.

Calvin

 

[Miha Markic]

Hi Calvin,

Try something like this:

Dim big5encoding As New Encoding.GetEncoding("big5")
oTempBuffer = Encoding.Convert(Encoding.GetEncoding(28591),
big5encoding , iso88591stringBytes) ' iso88591string is an array of bytes
Dim big5string = big5encoding .GetString(oTempBuffer)