Informix load/unload problem with UTF-8
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.