Informix load/unload problem with UTF-8

Asked By 200 points N/A Posted on -

Hi all,

I am working with two databases in Informix 10. Each one is on a different machine and I am trying to copy some data from one table to an identical table in the other database. Both databases are in UTF-8.

When I use the unload command in the source database, everything is fine, and I get my file with the data (although the file is not coded in UTF-8). But when I use the load command in the target database, the rows with special characters are causing errors in the insertion and the data after the character is all missed up. Has someone experienced this before? Thanks a lot for reading my question.

Best regards.

Answered By 590495 points N/A #84925

Informix load/unload problem with UTF-8


Although date and time is the same on both computers but the databases when it was saved are different.

The table maybe identical but they are not because of how it was created, when it was saved and the coding itself are different.

You may hard code the data into the row that has special characters on it. This is the main issue why you get this issue. The database might have been coded not to accept special characters and this caused the problem. Try to change the character reference to accept special characters.

Login/Register to Answer

Related Questions