Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Unanswered: Character sets in Oracle

    Hi,

    1. How can i find out the default character set used in Oracle?

    2. How could i reset the default character set with some other character set?

    Thanks,
    Sn

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Connected as a privileged user, issue
    Code:
    select value$ from sys.props$ where name = 'NLS_CHARACTERSET';
    and you'll get current character set. On MS Windows, you could also check registry and see NLS_LANG value. I wouldn't know about other operating systems.

    You'd change it using the ALTER DATABASE CHARACTER SET statement in Oracle versions prior to 10g; in 10g, check the Oracle Database Globalization Support Guide for information on database character set migration.

Posting Permissions

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