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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 11 Jun 2003 23:23:53 +0200
Message-ID: <je7fev8pn7pq3q4j6beqphcr4g64kto5qf@4ax.com>

On 11 Jun 2003 13:01:28 -0700, syawalkar_at_yahoo.com (Sumeet) wrote:

>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

select * from nls_database_parameters will do the trick.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 11 2003 - 16:23:53 CDT