var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: locale problem
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.
do not perform this at home
There is a way to solve it but it is not recommended. The article finishes with the sentence... can potentially lead to data corruption.
Originally Posted by rvsenthil
So if you have critical data in your databases is better to perform the safe solution.
The two databases have to speak the same language. So the safe solution is to export the one, change DB_LOCALE to be the same with the other and import again.