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.

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.