I'm currently trying to update a database with chinese data in it to a unicode database using visual basic as the conversion process.

The old database is set as US english codepage but is being written to by a webpage with Chinese encoding. The Chinese data is stored in the database as a string of random characters, which if for example is copied to a html page and then encoded views fine.

However I am now trying to move this chinese data into a Unicode database, which rather than displaying the correct chinese characters is showing the symbols exactly as they are in the database, even when veiwed using a utf8 webpage.

Is there any way that I can convert the ansi characters to BIG5 encoding and then to Unicode or even better go from the ansi characters straight to the correct Unicode characters for the symbols they are representing?

Any help gratefully received.