Character set /Language detection in ORACLE 8i and 9i

From: Sumeet <syawalkar_at_yahoo.com>
Date: 11 Jun 2003 13:01:28 -0700
Message-ID: <ba73b288.0306111201.6509b860@posting.google.com>

Hello,

I need some help with determining the language code/character set code for certain fields in a give table in oracle.

We store multi-byte data in our database which is 8.1.6 and 9.2 and created with UNICODE and the default character set code.

This allows us to store data in various languages without any conversion.

I wanted to know if there is an utility/function available that can detect the character set code/language code for data stored in a given column.

we have lot of multi-byte data which we think is corrupted and we need to find the corrupted data.

Thanks for your help in advance.
Sumeet Received on Wed Jun 11 2003 - 15:01:28 CDT