db2set codepage in not working in DB2 windows

1.6k views Asked by At

I am using DB2 version 9.7 and 10.1 both.When i execute the command to change the code page like "db2set db2codepage=1250" it does not show any error. but aftre that when i import the data then it throws the following error SQLCODE: -332 - SQLSTATE: 57017 *** SQL0332N Character conversion from the source code page "1252" to the target code page "1250" is not supported. SQLSTATE=57017

1

There are 1 answers

0
Israel Cruz Ibarra On

if the charset is utf-8 you should use DB2CODEPAGE=1208 on non-windows and 1252 on windows in the system and restart your application.