I have a sqlanywhere db in a machine with locale Chinese PRC.
I have a powerbuilder pipeline which read sqlanywhere data
to transfer to an oracle db with GBK charset. The action
result as the chinese data becomes meaningless character.
Which level of tuning shall I consider: sqlanywhere db setting,
pipeline sql conversion, oracle plsql conversion, or anywhere else,
to make a presentable oracle chinese record?
umm... I normally don't answer queries for people moving away from Sybase.. make an exception this time...just kidding...
SQL Anywhere, Chinese charset is cp934 or cp932 on Oracle can be mapped to UCS2. You may be looking at your data pipe on a Windows platform and seeing all the garbage, that's because windows cannot exactly map all the characters defined. However the garbage will make sense when piped into Oracle configured with UCS2.