Using two different character sets in one database

I have the following problem (I googled but found no answer): A database uses UTF8 character set. Some clients use WE8ISO8859P1 to insert data, some use UTF8, others even use WE8MSWIN1252. As I understood NLS you can use whatever character set you want IF it is a subset of the database' character set. In the above situation, when a client inserts WE8MSWIN1252 data reading it with UTF8 shows garbage. The same applies for WE8ISO8859P1 and UTF8. Do I have to use the same characterset for writing and reading or can I write data with a subset of the characterset used for reading?

Confused,

Eric Received on Mon Jul 29 2002 - 07:29:42 CDT