Start a new topic

DB2 AS/400 DBCS Double Byte Character

anonymous

started a topic about 9 years ago

[This topic is migrated from our old forums. The original author name has been removed]

I am querying data to DB2 AS/400 using DB Visualizer + JTOpen 400 but my data is encoded in DBCS as it may contain languages such as Thai, Korean, Japanese, Chinese. The result that is shown is fine when the text are in plain english but it gives me random characters when it has characters in DBCS. Can anyone help on how to configure so that it is showing correctly?

The client is running on Windows 7.

Sample text I get from the query which is not properly shown.

Îª×¡¯Ë Ð¯ÆÐ×Í Å×¿Ëª×Î×ÆûÇÞªÛ ê´â¯Å      

Thanks all.

1 Comment

Roger Bjärevall

said about 9 years ago

[This reply is migrated from our old forums.]

Re: DB2 AS/400 DBCS Double Byte Character

Hi,

Have you checked that you are using a font in DbVisualizer that is capable to show the letters? Verify this in Tools->Tool Properties and the General / Appearance / Fonts category.

Other than that we have no wide experience with DB2 AS/400. There is a driver property that may help in case the charset need to be encoded. Please check the following for more information:

http://www-03.ibm.com/systems/power/software/i/toolbox/faq/jdbc.html

Here is a list of driver properties supported by the JTOpen driver:

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html

To set a driver property in DbVisualizer do this in the Connection Properties tab and the Driver Properties category for your AS/400 connection.

I hope this helps.

Regards

Roger

How can we help you today?

DB2 AS/400 DBCS Double Byte Character

anonymous

Roger Bjärevall