Re: (-23197) : Database locale information mismatch.

This is possible only if the 2 tables are code set compatible. That too is true only from 9.40.UC1. Like zh_tw.big5 (chinese) and en_us.8859 are not codeset compatible and hence you would receive -23197. But fr_fr.8859 (french) and en_us.8859 are codeset compatible and hence you will be able to do that select.. |---------+----------------------------> | | "Leonid | | | Vorontsov" | | | <Leonids.Voroncov| | | s@dati.lv> | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 09/10/2003 04:39 | | | AM | | | Please respond to| | | "Leonid | | | Vorontsov" | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: (-23197) : Database locale information mismatch. | | | >-------------------------------------------------------------------------------------------------------------------------------| Hi all! Suppose I have connection to a db with concrete locale and want read data from another one with other locale (like from sysmaster:anytable), but sever gives me subj error. Is this operation possible at all? sending to informix-list