OraFAQ Forum: Server Administration » Charater sets usage in oracle

Home » RDBMS Server » Server Administration » Charater sets usage in oracle (oracle 9i, 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Charater sets usage in oracle [message #277605]

Tue, 30 October 2007 14:37

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.

Report message to a moderator

Re: Charater sets usage in oracle [message #277607 is a reply to message #277605]

Tue, 30 October 2007 14:40

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: Charater sets usage in oracle [message #277608 is a reply to message #277605]

Tue, 30 October 2007 14:42

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

Report message to a moderator

Re: Charater sets usage in oracle [message #301517 is a reply to message #277608]

Wed, 20 February 2008 23:19

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.

Report message to a moderator

Re: Charater sets usage in oracle [message #301572 is a reply to message #301517]

Thu, 21 February 2008 01:08

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Globalization Support Guide

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:55:07 CDT 2024