member list with non english characters

the vscode new version use select to get member lishis is the sql - Call QSYS2.QCMDEXC('CHGJOB CCSID(424)');
with MEMBERS as ( select rtrim(cast(a.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY, b.AVGROWSIZE as RECORD_LENGTH, a.IASP_NUMBER as ASP, rtrim(cast(a.SYSTEM_TABLE_NAME as char(10) for bit data)) AS SOURCE_FILE, rtrim(cast(b.SYSTEM_TABLE_MEMBER as char(10) for bit data)) as NAME, coalesce(rtrim(cast(b.SOURCE_TYPE as varchar(10) for bit data)), '') as TYPE, coalesce(rtrim(varchar(b.PARTITION_TEXT)), '') as TEXT, b.NUMBER_ROWS as LINES, extract(epoch from (b.CREATE_TIMESTAMP))*1000 as CREATED, extract(epoch from (b.LAST_SOURCE_UPDATE_TIMESTAMP))*1000 as CHANGED from QSYS2.SYSTABLES as a join QSYS2.SYSPARTITIONSTAT as b on ( b.SYSTEM_TABLE_SCHEMA, b.SYSTEM_TABLE_NAME ) = ( a.SYSTEM_TABLE_SCHEMA, a.SYSTEM_TABLE_NAME ) ) select * from MEMBERS where LIBRARY = 'CRMPGM' and SOURCE_FILE = 'QRPGLESRC' and NAME like '%' and TYPE like '%' order by NAME ASC.

This select if perfectly fine when using jdbc connection however when going via the QZDFMDB2 it returned garbage hebrew , i suspect it is locale issue but i do not have local specific to my lanaguage and it is not documented. Is there a setting that will force conversion to utf-8 ?

⚠️ **REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW!** ⚠️

|Context|Version|
|-|-|
|Code for IBM i version|2.16.3|
|Visual Studio Code version|1.102.2|
|Operating System|win32_x64|

Active extensions

```
COBOL (cobol): 25.7.25
ChatGPT - Genie AI (chatgpt-vscode): 0.0.13
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Db2 for IBM i (vscode-db2i): 1.13.3
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.26.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.346.0
GitHub Copilot Chat (copilot-chat): 0.29.1
GitLens — Git supercharged (gitlens): 17.3.2
IBM i Debug (ibmidebug): 3.0.0
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Source Orbit (vscode-sourceorbit): 1.4.0
TODO Highlight (vscode-todo-highlight): 1.0.5
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
```

**_Not connected_** 🔌