Hi,
I am getting an error while importing a database on Informix 11.50 TC8 on Windows-2003. This database has been exported from Informix 11.50 FC4 on AIX 5.3.


The same database is imported successfully on Informix 11.50 FC4 on AIX 5.3
and in Informix 9.40.TC7 on Windows-2003.

So I don't understand what is is actual cause of this failure under 11.50 TC8.

If anyone has encountered this error, please let me know how it can be fixed.
My environment setting for DB_LOCALE and CLIENT_LOCALE are as under.

DB_LOCALE=EN_US.8859-1
CLIENT_LOCALE=EN_US.CP1252



Best Regards
Arvind Kumar

Hi,

I've seen this before - Windows and Unix locales are slightly different. I've got a database on linux which uses the euro symbol and works fine with EN_US.8859-1, but it won't import on Windows, I had to set DB_LOCALE to EN_US.8859-15.

HTH

Phil Rule

Oninit Group | Informix Services, Informix Consultant and Informix DBA Services