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

Thread: Character Set Modification

  1. #1
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    Character Set Modification

    Hi All,

    All our databases have

    nls_language = American

    I've been asked if I can include a table with French and German Name and Addresses, including accents (and I don't mean speaking in a funny way!)

    Can this be done, i.e., can you change the characterset for a table, or is the characterset defined when you create the database?

    If so, would I need to create a new database with a european characterset and import the 'american' tables into it.

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    You better check the NLS_CHARACTERSET.
    Characterset CANNOT be modified based on table-level.
    It is database-level.
    You can import the tables into the new database with the expected characterset.
    But there are some restrictions such as the new characterset must be the superset of the old one.
    Last edited by Lily_Liu_2004; 11-02-2005 at 11:44 AM.

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by Horace
    Hi All,


    Can this be done, i.e., can you change the characterset for a table,
    NO


    or is the characterset defined when you create the database?

    YES

    If so, would I need to create a new database with a european characterset and import the 'american' tables into it.
    No not needed!

    To explain how to change the database character set or national character set of an existing Oracle8(i) or Oracle9i database without having to recreate the database.

    refer the metalink doc:
    https://metalink.oracle.com/metalink...T&p_id=66320.1
    "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