Character set are defined the database level. If you have two different databases, then you can have any two different character sets you wish. This is generally defined at the time you run the "create database..." statement.
Understand of course that in your scenario there would be limits on sharing data between the two databases. The UTF8 database could handle anything stored in the USASCII database because it is a superset, but you could not necessarily share data the other direction. -Ron- -----Original Message----- Richmond Sent: Monday, November 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and Oracle binaries were installed with US7ASCII, how can you convert it to UTF8 without having to reinstall everything? This is Oracle 8.1.7.3 on Solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron/Sarah Yount INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
