Oracle Database Discussions

Hello -

I have 2 databases running in 2 different character sets.
I am able to insert the following french accents in both databases and stored correctly also in db and displayed correctly in sql plus -
à À Ä ä Â â é É È è Ë ë Ê ê î Î ï Ï ç Ç Û û ô æ ö « »

But the following 2 charactes donot get displayed/stored correctly in any of the databases -

œ Œ

1. For db running in UTF8 character set it stores/displays as follows -
¿ ¿

2. For db running in WE8ISO8859P1 character set it displays as 2 filled black squares. But when I do 'copy and paste'. It is pasteing correctly in the editor as follows -
œ Œ

I have another one database running in same WE8ISO8859P1 character set , DBA out there sent me the results from sql plus for the above 2 characters and they are getting displayed as well as stored fine.

I have the following questions -

1. Besides database characterset what else parameters or environment variables I need to check the for these characters to be displayed/stored correctly ?

2. Why would Databases with same characterset gives different results for the same characters ?

3. UTF8 is superset of WE8ISO8859P1 characterset, then why in that UTF8 db is unable to store that characters
which were able to be stored in WE8ISO8859P1 db.


By these various results, I am very confused and not able to troubleshoot further.

Any help would be very much appreciated...

Thanks
Rama