Informix load/unload problem with UTF-8

Asked By 200 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 567105 points N/A #84925

Informix load/unload problem with UTF-8

qa-featured

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