when I try connect to remote db using web aplication (apache+php), I get error "IBMCLI Driver SQL0332N Character conversion from the source code page "819" to the target code page "UNKNOWN" is not supported. SQLSTATE=57017"
Php script executed directly (php -f sctipt.ph) is working. Also connection throught isql command working too.
Server - win2003 db2 9.5 codepage 1250
Client - linux 64.bit Debian Squeeze, ibm client 10.1, codepage utf-8.
attached trace log file
Description = Test to DB2
Driver = DB2
Trace = yes
Tracefile = /tmp/odbc.log
Description = DB2 Driver
Driver = /opt/ibm/db2/odbc_cli/clidriver/lib/libdb2o.so
FileUsage = 1
DontDLClose = 1
If remote database is with utf-8 codepage, connection from web application works. I can`t change remote db codepage.
This topic has been locked.
4 replies Latest Post - 2013-03-12T09:20:57Z by odb
Pinned topic apache+php+driver for odbc cli - connect problem with character conversion
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-12T09:20:57Z at 2013-03-12T09:20:57Z by odb
nivanov1 100000H9H753 PostsACCEPTED ANSWER
Re: apache+php+driver for odbc cli - connect problem with character conversion2013-03-04T14:41:55Z in response to odbCheck if Apache passes correct environment variables when it invokes PHP; the DB2 driver will use LANG or LC_CTYPE variables to determine the client code page.
Re: apache+php+driver for odbc cli - connect problem with character conversion2013-03-08T14:51:35Z in response to odbSolved by adding line to db2cli.ini
I found this here -> http://support.mdl.ru/Pc_compl/Doc/Db2/v7.1/en/Html/db2ir/db2ir314.htm
or in Call Level Interface Guide and Reference, Volume 1
Find something in huge IBM documentation is very hard, sometimes.