Informix load/unload problem with UTF-8

Asked By b.jai75 200 points N/A Posted on - 07/22/2011

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.

• Status: Open
• Question Views: 2658
• Answer Count: 1
• Vote Up 20 Vote Down

• Answer Accepted: No
• Question Category: Informix

Answered By Sharath Reddy 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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 09/25/2011
• Question Category: Informix