Home » RDBMS Server » Server Administration » Charater sets usage in oracle (oracle 9i, 10g)
Charater sets usage in oracle [message #277605] Tue, 30 October 2007 14:37 Go to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,


Can someone provide the importance / difference of the following:

Database Character Set.

National Character Set.

Default Language.

Default Date Format.


Thanks,
Priya.




Re: Charater sets usage in oracle [message #277607 is a reply to message #277605] Tue, 30 October 2007 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is the third person in 2 weeks that asks about database character set and national character set. Is this a new fashion?

A good link:
http://www.oracle.com/pls/db102/db102.federated_search

Regards
Michel
Re: Charater sets usage in oracle [message #277608 is a reply to message #277605] Tue, 30 October 2007 14:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
  1* select PROPERTY_NAME,PROPERTY_VALUE from database_properties
SQL> /

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ ------------------------------
DICT.BASE                      2
DEFAULT_TEMP_TABLESPACE        DS_TEMP
DEFAULT_PERMANENT_TABLESPACE   DS_USER
DBTIMEZONE                     +00:00
DEFAULT_TBS_TYPE               BIGFILE
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               US7ASCII

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ ------------------------------
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ ------------------------------
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.3.0
GLOBAL_DB_NAME                 DS.OMZESP07.MCILINK.COM
EXPORT_VIEWS_VERSION           8

27 rows selected.

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


http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a67789/ch1.htm
Re: Charater sets usage in oracle [message #301517 is a reply to message #277608] Wed, 20 February 2008 23:19 Go to previous messageGo to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,

Thanks for replying about how to obtain their values from querying database tables.

But the question was not about getting their values, but it is about how does setting these parameter:

Database Character Set.
National Character Set.
Default Language.
Default Date Format.

have the impact on the database while using or while importing / exporting.

Thanks,
Priya.

Re: Charater sets usage in oracle [message #301572 is a reply to message #301517] Thu, 21 February 2008 01:08 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Globalization Support Guide

Regards
Michel
Previous Topic: archive log destination filling very fast
Next Topic: ORA-39700 on newly created database
Goto Forum:
  


Current Time: Fri Nov 29 23:52:36 CST 2024