code page issue using driver

[Andy Miles]

When I connect to a server in China i get the following error:

Exception: Column information cannot be retrieved: [IBM][CLI Driver][DB2/SUN64] SQL0332N  Character conversion from the source code page "1383" to the target code page "1252" is not supported.

 SQLCODE=-332

I have no issues in any other locations. I have tried to find a solution online but to no avail. Please help! Thx

[Saba Kauser]

Hello Andy,

Is your db in code page 1252 and your client(application) codepage is 1383?

Please collect traces on your client and share the files.

cd `clidriver install path`
cd adm
db2trc on -f trc.dmp
`run your application`
db2trc off
db2trc flw trc.dmp trc.flw
db2trc fmt trc.dmp trc.fmt
db2trc fmt -c trc.dmp trc.fmtc
and share the trc.flw, trc.fmt and trc.fmtc files with us to assist you further.

can you collect cli traces as follows:
edit db2cli.ini file(under clidriver/cfg) and add following entries, add an empty last line: change tracepathname value to your path

[common]
trace=1
tracepathname=/home/skauser/sample_cases/trace
traceflush=1

and share trc.flw, trc.fmt, trc.fmtc and the CLI trace files under 'tracepathname'. The CLI trace files are with naming convention p<pid>t<tid or identifier>.cli . eg: p26390t726578976.cli