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.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
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 Posts
Re: apache+php+driver for odbc cli - connect problem with character conversion2013-03-04T14:41:55ZThis is the accepted answer. This is the accepted answer.Check 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:35ZThis is the accepted answer. This is the accepted answer.
- odb 0600023BVF
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.
Re: apache+php+driver for odbc cli - connect problem with character conversion2013-03-12T09:20:57ZThis is the accepted answer. This is the accepted answer.
- odb 0600023BVF
Edit line in /etc/apache2/envvars (Debian)
from export LANG=C to export LANG=en_US.utf8