Inexact Character Conversion During Translation

Symptoms

While migration from Informix database there might be an error specified below:
[Informix][Informix ODBC Driver]Inexact character conversion during translation.

Cause

This problem maybe caused by the difference in Collations used on Client and on Server where Informix is running.

Solution

The solution of character conversion error is quite simple. Need to specify explicitly for Client Locale the same locate as for Database Locale like in the screenshot below.

Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays