informix dbimport throws 23103 - Code-set conversion function failed due to illegal sequence or invalid value

Question

When I try to import an informix database with command dbexport -c <mydbname> <myDbspace> that was already exported. I get this Error: 23103 - Code-set conversion function failed due to illegal sequence or invalid value.

I wonder if this is related to whether the text encoding I try to import is not compatible or something like that..

This is the full log:

{ TABLE "informix".XXX row size = 134 number of columns = 19 index size = 8 }

{ unload file name = XXX__00103.unl number of rows = 7 }

create table "informix".XXX
  (
    XXX_id char(3) not null ,
    XXX_name char(50) not null ,
    XXX_dec_nb decimal(1,0) not null ,
    XXX_rounded decimal(4,3) not null ,
    XXX_symbol char(3) not null ,
    XXX_location decimal(1,0)
        default 0 not null ,
    XXX_negative decimal(2,0) not null ,
    XXX_dec_char char(1) not null ,
    XXX_group_char char(1) not null ,
    XXX_euro decimal(16,8) not null ,
    XXX_active decimal(1,0)
        default 1 not null ,
    XXX_coef decimal(7,3),
    XXX_rnd_0 decimal(7,2) not null ,
    XXX_rnd_1 decimal(7,2),
    XXX_rnd_2 decimal(7,2),
    XXX_rnd_3 decimal(7,2),
    XXX_rnd_4 decimal(7,2),
    XXX_rnd_5 decimal(7,2),
    XXX_cts_desc char(20),

    check (((XXX_active >= 0. ) AND (XXX_active <= 1. ) ) AND (XXX_active IN (0.
              ,1. )) ) constraint "informix".ckc_XXX_acti_XXX,

    check (((XXX_location >= 0. ) AND (XXX_location <= 3. ) ) AND (XXX_location IN (0.
              ,1. ,2. ,3. )) ) constraint "informix".ckc_XXX_loca_XXX,
    primary key (XXX_id)  constraint "informix".pk_XXX
  );

revoke all on "informix".XXX from "public" as "informix";
*** put loadXXX
23103 - Code-set conversion function failed due to illegal sequence or invalid value.

EDIT:

FIXED:

Changed my 'servername'.cmd file in C:\Program Files\IBM Informix Software Bundle by setting:

• set CLIENT_LOCALE=EN_US.8859-1
• set DB_LOCALE=EN_US.8859-1

Answer 1

FIXED:

Changed my 'servername'.cmd file in C:\Program Files\IBM Informix Software Bundle by setting:

• set CLIENT_LOCALE=EN_US.8859-1
• set DB_LOCALE=EN_US.8859-1