This is a discussion on db2 connection problem (codepage) within the DB2 forums, part of the Database Server Software category; --> lvmbi@worf:~$ db2 connect to sqldba user username using difficultpwd SQL0332N Character conversion from the source code page "923" to ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| lvmbi@worf:~$ db2 connect to sqldba user username using difficultpwd SQL0332N Character conversion from the source code page "923" to the target code page "UNKNOWN" is not supported. SQLSTATE=57017 lvmbi@worf:~$ The documentation speaks about setting the environment variable LC_ALL to de_DE@euro. But that does not help. That target code page is still unknown. Does anybody know what to do ? Regards Michael |
| ||||
| michael.bierenfeld@web.de wrote: > in /etc/default/locale > > LANG=de_DE.iso88591 > > is your friend I thought that 923 was 8859-15 and I believe that there are characters in 8859-15 that are not in 8895-1 Is the client with the problem on the same or a different system to the DB2 server. I assume that you can connect from the instance owner on the same system as the server. Compare the working with the not working, in particular the conversion files in /.../instanceowner/sqllib/conv. Also the environmet varialbs such as LANG It is also possible that the version of DB2 may make a difference. Are the client and server the same version and fixpack Colin |