I'm running a Informix 7.31 database server on windows 2000.
This database has the single purpose of holding all of our ERP data (built by a brazilian company) and is accessed only by this application that handles data interaction via ODBC, clients don't access the DB directly. They have access to an application server that talks to the database layer application that talks to informix. (hope i made myself clear there.. ).
My problem seems to be due to diferent locales on the database and on the data that is entered into it. The DB uses en_US.819 (which i believe is informix' default) and the clients enter data that has iso-8859-1 characters, brazilian ones.
Here's the error i get in ODBC: Error=21005[Informix][Informix ODBC Driver]Unspecified System Error = -21005.
and then the row doesn't get updated.
i coudn't find anything related to that error anywhere, but i'm pretty sure that's the problem.
my question is. Is there anyway to change the database locale without having to export all the data, dropping the database, recreating the database with a different charset (which i'm not entirely sure how to do) and then re-importing the data back?
the server in question (HP Proliant 370, 2x 3,06 GHz HT, 4GB RAM, ~60GB RAID 5) takes about 2 hours to export the data (~ 6 GB) and around 3,5 hours to import it back using dbexport and dbimport (is it too slow?).
Any help is greatly appreciated as i've just started managing this database a couple of weeks ago and am still getting the hang of it.