Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004

    Red face Unanswered: Sqlanywhere chinese data handling...

    Dear all,

    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?


  2. #2
    Join Date
    Nov 2002
    Probably due to bad characterset convertion in the PB side. Did you install the necessary Windows charactersets ?Is it possible to disply your characters through a simple PB datawindow ?

  3. #3
    Join Date
    Feb 2004
    thx for reply...

    all pb reports display normally in chinese, but fail in upload
    to oracle... there seems a odbc translator in sqlanywhere
    driver something...but donno if can help?

    anyother workaround ?

  4. #4
    Join Date
    Feb 2002
    Willy is on vacation
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts