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.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 590495 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.

About Sharath Reddy
Questions
1
Answers
14599
Best Answers
2290
  • Posted on -
  • Question Category:

The site didn't send the forgotten password.

Previous

Better Performance of DISTINCT and GROUP BY

Next

Related Questions