Re: Using two different character sets in one database

From: Eric Menzel <oracle8_at_firemail.de>
Date: 30 Jul 2002 00:12:23 -0700
Message-ID: <58d6a85c.0207292312.6f3ee876@posting.google.com>

> > 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?

Yes, that's why I wrote, what character set they use to insert data.

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

Thank you, but I already did that. I found nothing about how Oracle handles character set conversion like WE8ISO8859P1->UTF8. I'll keep searching.

Thanks anyway,

Eric Received on Tue Jul 30 2002 - 02:12:23 CDT