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. To do this would I
access the FB 2.0 DB using the .RawBytes property?

Any other suggestions would be pre appreciated.

Thanks
Rob