Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Mon Feb 20 2006 - 15:34:44 CST