Data with Japanese charcters are not displayed

[kyokonishito]

We can not display any Japanese charcters.

• Platform: Mac Catalina 10.15.7
• vscode Version: 15.7.1
• Is node.js and npm installed: yes
• node.js and npm Version: v14.15.4 and 6.14.10
• Take a screen shot of VScode(Help->About) information and paste it: Version: 1.57.1 Commit: 507ce72a4466fbb27b715c3722558bb15afa9f48 Date: 2021-06-17T13:28:32.912Z Electron: 12.0.7 Chrome: 89.0.4389.128 Node.js: 14.16.0 V8: 8.9.255.25-electron.0 OS: Darwin x64 19.6.0

Steps to Reproduce:

1. Connect to a db2 db

2. Show the tree view and we can not see Japanese characters in a table name. The actual table name is COVID_19_東京.

3. Click a table name COVID_19_ which has all column names with Japanese characters from the tree view . We can not see any colum names and we received No COLUMNS in this tables error.

4. Right click a table name COVID_19_ and click 'Select Top 1000', then we received an error Query execution failed: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "NISHITO.COVID_19_ " is an undefined name. SQLSTATE=42704.

5. Right click a table name MEMBER which has Japanese characters in NAME column and click 'Select Top 1000', then we can not see any Japanese characters in NAME column.

I attached the images with DBeaver which is an OSS tool , can display Japanese correctly for your infomation:

[akhilravuri1]

Hi @kyokonishito

I will try to reproduce the issue.

Thanks, Akhil

[akhilravuri1]

Hi @kyokonishito

I am able to reproduce the issue. I Will let you know if this can be solved using a change in settings or env.

Thanks, Akhil

[jgantriis]

We are having similar problems using codepage 1252. Any way to set codepage via the optional connection properties?

[kyokonishito]

I confirmed Japanese characters can be displayed with v2.3.0. Thanks.