Home » RDBMS Server » Server Administration » Why I cannot set the Charactor Set while installing. (ORACLE10g 10.2.0 RHEL5)
Why I cannot set the Charactor Set while installing. [message #310407] Tue, 01 April 2008 02:42 Go to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
whatever my OS' language is English or Chinese, the Charactor set of the database I choose is ZHS16GBK or UTF8, after the installation is completed, the parameter NLS_LANGUAGE's value always is "AMARICAN":just like the following:
SQL> show parameter nls

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_calendar                         string
nls_comp                             string
nls_currency                         string
nls_date_format                      string
nls_date_language                    string
nls_dual_currency                    string
nls_iso_currency                     string
nls_language                         string      AMERICAN
nls_length_semantics                 string      BYTE
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string
nls_territory                        string      AMERICA
nls_time_format                      string
nls_time_tz_format                   string
nls_timestamp_format                 string
nls_timestamp_tz_format              string



how can I install the ZHs16GBK or other Charactor Set?
thank you!
Re: Why I cannot set the Charactor Set while installing. [message #310411 is a reply to message #310407] Tue, 01 April 2008 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
use nls_database_parameters to get your database character set.
nls_language is a language not a character set.

Regards
Michel
Re: Why I cannot set the Charactor Set while installing. [message #310416 is a reply to message #310411] Tue, 01 April 2008 03:23 Go to previous messageGo to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
I have set the Charactor Set, but why I can not find the parameter NLS_DATABASE_PARAMETERS ?
Re: Why I cannot set the Charactor Set while installing. [message #310423 is a reply to message #310407] Tue, 01 April 2008 03:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

SQL> desc NLS_DATABASE_PARAMETERS;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PARAMETER                                 NOT NULL VARCHAR2(30)
 VALUE                                              VARCHAR2(40)
Re: Why I cannot set the Charactor Set while installing. [message #310533 is a reply to message #310423] Tue, 01 April 2008 09:19 Go to previous message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
I'm so ashamed of this. I thought NLS_DATABASE_PARAMETERS is a parameter.
thanks Michel and Arju, I appreciate your help.
Previous Topic: ORA-12012: error on auto execute of job 425
Next Topic: Steps to create database
Goto Forum:
  


Current Time: Thu Dec 08 20:09:03 CST 2016

Total time taken to generate the page: 0.09796 seconds