different character sets on same server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: different character sets on same server

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    Can I have two databases with different character sets (eg. US English & UTF8) on the same Oracle server?

    I don't recall Oracle installer asked me for character set during the Oracle SOFTWARE installation but only during DB creation. Is it correct?

    Thanks,

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282


    you can have database character set and national character set, exactly US7ASCII and UTF8 as you wanted. When you want to use US7ASCII, just use CHAR, else if you wnat UTF, use NCHAR.


    F.

  3. #3
    Join Date
    Jun 2002
    Posts
    62
    While creating db u can chose any character set. It is a part of Create Database command. If you do not specify it, Oracle will use the default character set. U cannot change the character set after creating the db.
    Regards,
    Jack

  4. #4
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    So that means on the same physical server, I can have one database with character set and NLS charset to UTF8 and another database wtih character set and NLS charset to WE8ISO8859P1?

    Thanks,

  5. #5
    Join Date
    Jun 2002
    Posts
    62
    Yes
    Regards,
    Jack

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jack9190
    U cannot change the character set after creating the db.
    That's not true. You can change the character set.

    Example:
    Code:
    alter database character set UTF8;
    Check Metalink Note:123670.1
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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