Subject | Chinese Pinyin to Unicode |
---|---|
Author | Robert Martin |
Post date | 2015-03-19T20:07:09Z |
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
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