We are using UTF8 in the database (database stored mix of Eastern and Western European languages), WE8MSWIN1252 - for Western European clients, and EE8MSWIN1250 - for Eastern European clients (yeah, it's Win clients). Works fine for us. Igor Neyman, OCP DBA ineyman@xxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nuno Souto Sent: Tuesday, March 16, 2004 6:58 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Oracle does not (always) understand French - was RE: Use of the q uote / apostrophe in text fields This is actually an interesting problem. Coming from a background of "`,',and ç" stuff myself, these things are somewhat relevant. Does anyone know of a reference on which characters and native languages are best supported by each of the WE8* and US7* settings and their relationships to the client? Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ----- Original Message ----- From: "Robson, Peter" <pgro@xxxxxxxxx> Actually, this conundrum is all down to different character sets ( WE8ISO8859P1, and US7ASCII ) being established on different instances. Oh Really... Just something to watch out for. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------