1. Gilbert L
  2. PowerBuilder
  3. Wednesday, 17 July 2024 08:00 AM UTC

Chinese characters couldn't be displayed when querying a DB2 table in PowerBuilder. Could someone help on this? Thanks.

 It could be displayed when querying in DB2 command windows.

Attachments (1)
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 18 July 2024 07:18 AM UTC
  2. PowerBuilder
  3. # 1

Hi Gilbert,

 

Thanks for reporting this issue!

I didn’t reproduce this problem locally.

Please help provide more information:

  1. What’s your PowerBuilder version?
  2. What’s your DB2 ODBC driver version?
  3. What is the character set or codepage used by DB2 to create the Database?

 

Best Regards,

Peter

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 17 July 2024 19:21 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Gilbert -

It's difficult to say for certain, but typically, issues relating to incorrect characters being read, displayed or written are due to encoding differences. PB uses Unicode 16LE (LE -> Little Endian) encoding internally since PB 10.0, which was released in 2004, I believe.

I have no idea what encoding DB2 utilizes.

It's always a good idea to include the version, release and build of PB that you are using in your posts, as this can greatly affect the response(s) you may receive.

For database-related questions, it is highly recommended that you include information about the DBMS vendor (DB2, in this case), the version, and all of the properties of the PB Transaction Object (masking any sensitive values for security reasons, of course).

Best regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.