Re: Q: How to know the CHARACTER SET of a created Database

ppf_at_uninova.pt (Pedro Pimentel) writes:
: How can I know the CHARACTER SET of an existing database ?
:
: Thanks
:
: --
: Pedro Pimentel
: Faculdade de Ciencias e Tecnologia / Universidade Nova de Lisboa - Portugal
: e-mail: ppf_at_uninova.pt
: www: http://terra.uninova.pt/pedro/pedro1.html
: Benfica Home Page: http://terra.uninova.pt/pedro/slb/slbindex.html

SQL> desc sys.V_$NLS_PARAMETERS

 Name                            Null?    Type
 ------------------------------- -------- ----
 PARAMETER                                VARCHAR2(64)
 VALUE                                    VARCHAR2(64)

  1* select * from sys.V_$NLS_PARAMETERS

PARAMETER                                VALUE
---------------------------------------- ------------------------------
NLS_LANGUAGE                             AMERICAN
NLS_TERRITORY                            AMERICA
NLS_CURRENCY                             $
NLS_ISO_CURRENCY                         AMERICA
NLS_NUMERIC_CHARACTERS                   .,
NLS_DATE_FORMAT                          DD-MON-YY
NLS_DATE_LANGUAGE                        AMERICAN
NLS_CHARACTERSET                         US7ASCII
NLS_SORT                                 BINARY

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, Oracle European Development Centre, World Wide Education 
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+