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?
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.
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.
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?
That's not true. You can change the character set.
Originally posted by jack9190
U cannot change the character set after creating the db.
Check Metalink Note:123670.1
alter database character set UTF8;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width