URGENT how to find character set ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT how to find character set ?

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    URGENT how to find character set ?

    Hello gurus..

    9.0.1...

    How do i find out the character set in a database ?...

    thanks
    ron

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    There are other ways to check.

    Code:
    SQL> desc nls_database_parameters
    Name                                    Null?    Type
    --------------------------------------- -------- -------------
    PARAMETER                               NOT NULL VARCHAR2(30)
    VALUE                                            VARCHAR2(40)
    How do I find which settings I currently have for NLS features?

    NLS_DATABASE_PARAMETERS - defaults set up for the database at creation

    NLS_SESSION_PARAMETERS - parameters set by NLS_LANG or alter session (does not include client character set)

    NLS_INSTANCE_PARAMETERS - parameters set in init.ora

    V$NLS_PARAMETERS - values of NLS parameters for current values

    V$NLS_VALID_VALUES - values which can be used for CHARACTERSET, LANGUAGE, TERRITORY, SORT (dependent on what was loaded at install time)
    Last edited by stecal; 01-13-2003 at 04:52 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width