Hi All,

I have one interesting problem in informix.

I have two database in one instance.

One database has been created with DB_LOCALE=en_US.819
Another database has been created with DB_LOCALE=en_US.UTF8

We have a query, which is collecting a data from both the databases.
It is giving error "locale information mismatch".

How can i solve this scenario?

If i set DB_LOCALE=en_US.819 then , i couldn't execute the query on other database. If i set DB_LOCALE=en_US.UTF8, first database query is not working.

Please advice me on this.

Thanks,
R V