Blog Archive

Character conversion between CCSID 65535 and CCSID 1208 not valid

I recently received this error when doing an SQL update on a system table.
Changing the JOB CCSID fixed the issue.

CHGJOB CCSID(37)

-- OR --

CHGSYSVAL SYSVAL(QCCSID) VALUE(37)
  • The default QCCSID on the iSeries is 65535. It is recommended that you change this value to your local language. In the United States, the value is 37 which is English.
  • Changing the QCCSID occurs immediately. You do not have to IPL (initial program load) the machine but at the next IPL, this value will be stored.