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