SQLSTATE 01517 - A character that could not be converted was replaced with a substitute character

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software
SQLSTATE 01517 - A character that could not be converted was replaced with a substitute character

Software

IBM DB2 Database

Symptoms

When exporting data from a DB2 database, the SQLSTATE 01517 message returned.

Actions

SQLSTATE 01517 means that you are using a database containing native language data (German or French e.g) and you have not configured the IBM DB2 client software to work with native language databases.

Set the appropriate value for the DB2CODEPAGE registry variable on the client workstation. Please refer to the IBM DB2 Documentation for the codepage values.