Re: Using two different character sets in one database

"Eric Menzel" <oracle8_at_firemail.de> wrote in message news:58d6a85c.0207290429.5d238220_at_posting.google.com...
> 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.

Did the client have the proper NLS_LANG env setting enabled when he put this data?

> 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

I would suggest that you read the NLS faq on technet: http://otn.oracle.com/products/oracle8i/htdocs/faq_combined.htm

Thanks,

Anurag Received on Mon Jul 29 2002 - 17:50:00 CDT