Re: thai characters

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 11 Mar 2002 19:09:03 +0100
Message-ID: <1jsp8u0jv8bpnfhns4a90kt6dvge328pmg@4ax.com>

On 11 Mar 2002 07:28:47 -0800, daud11_at_hotmail.com (Daud) wrote:

>I have a database where the database charset is UTF8.
>I created a simple table and store some Thai messages using sqlldr.
>The messages have been verified using VB to be correctly stored in
>thai.
>Now I would like to be able to see the records in sqlplus...how do I
>setup sqlplus so that I can see thai characters?
>
>I did 'alter session set nls_language=thai' and changed the language
>settings to thai in regional settings (under control panel) but it did
>not work.
>Anything else I need to do?
>
>rgds
>Daud

Without setting NLS_LANG in the registry nothing will happen. The syntax for NLS_<ANG = "<territory_region.charset" select * from v$nls_valid_values will show you allowable values.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 11 2002 - 12:09:03 CST