Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: Informix load/unload problem with UTF-8

    Hi all!

    I'm working with 2 databases in Informix 10. They are in different machines, and I'm trying to copy some data from one table to an identical table in the other database. Both databases are in UTF-8.

    I use the unload command in the source database and no problem, 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 (like ) are causing errors in the insertion and the data after the character is all messed up.

    I suppose it's a locales problem; I've set DB_LOCALE=en_US.utf8 in my client's (AGS Server Studio) configuration for both databases which is the only setting I know I must specify.

    Has someone experienced that before? Do you happen to know which settings I have to change in order to make this work with load/unload commands (maybe I need a different client)? Or it's impossible to copy data using these commands when the databases are in UTF-8?

    Thanks a lot for reading me, best regards!

  2. #2
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    Why don't you use dbaccess to export and import data?
    LS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •