NLS Characterset
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NLS Characterset

  1. #1
    Join Date
    Jun 2006
    Posts
    1

    NLS Characterset

    We are running an Oracle 10g database using the WE8ISO8895P1 NLS Characterset.

    We have an application server which communicates with the database using an Oracle 10g client. The NLS setting in application server is WE8MSWIN1252.



    I have the following questions:



    a) Which NLS Characterset will my database use when the application connects to the database? In other words which NLS characterset takes precedence, the database or the one in application server?

    b) Because the application server (client) character set is different that database characterset, will it corrupt the binary values in the database?

    c) How can I find if the binary values that are stored in the database are right and not corrupted?



    I need detailed answers. Can you guys help?

  2. #2
    Join Date
    Jun 2006
    Posts
    6
    SQL> select * from nls_database_parameters;


    PARAMETER VALUE
    ------------------------- -------------------------

    NLS_LANGUAGE AMERICAN
    NLS_TERRITORY AMERICA
    NLS_ISO_CURRENCY AMERICA
    NLS_CHARACTERSET WE8MSWIN1252
    NLS_DATE_FORMAT DD-MON-RR
    NLS_DATE_LANGUAGE AMERICAN

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    b) You can set the database and apllication compatible to Character set,National character set.

    If its other than the required parameters which may not be compatible to your application, you may not see the right output.
    "What is past is PROLOGUE"

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