Re: Error :: Need help about setting environment for thai support.

On 20 Feb 2006 13:15:29 -0800, "Pratchaya" <pratchaya_at_banana.co.th> wrote:

>i see instruction from this page.
>http://pupa.exzilla.net/docs/nls/oracleNLS01.php
>
>and go with this line.
>======================================================
>Environment level This way will effect only client that uses this
>environment
>
> Terminal session
>(Multi-user environment such as telnet)
>In UNIX environment, set the environment variable as follows:
>In born, korn shell
>$NLS_LANG=THAI_THAILAND.TH8TISASCII; export NLS_LANG
>======================================================
>

The page is full of errors, and contains unprofessional advice like updating sys.props$ to change the characterset of a 7.3.4 database The syntax above is incorrect, and born shell doesn't exist, it is *bourne* shell.
It should be
NLS_LANG="THAI_THAILAND.TH8TISASCII"; export $NLS_LANG.

Also in init.ora it is NLS_LANGUAGE not NLS_LANGAUGE.

Never ever trust *non-oracle* 'documentation'

--
Sybrand Bakker, Senior Oracle DBA