Subject Chinese Pinyin to Unicode
Author Robert martin
Hi

I have some data that appears to be Chinese entered using Pinyin. The
data is stored in a FB 2.0 DB in Charset NONE. We want to port the data
over to a FB 2.5 DB with Charset UTF8. Just pumping the data does not
work. We thought we had solved it by Exporting from the DB to a UTF8
formatted file of insert statements then loading from the script on a
machine with Chinese installed. However we have been informed that
these characters are now Japanese and make no sense.

So what I suspect I need to do is take the data in raw btye format and
convert it to the appropriate Unicode character.

Does this sound like the appropriate solution? Any one know how to do it?

Any other suggestions would be pre appreciated.

Cheers
Rob