1) You can have two databases with different character sets in the same
computer.
you may have problems running local jobs, but I do not know Solaris to
comment on this.
2) according to metalink doc#: 119164.1, UTF8 is a superset of US7ASCII so
you can convert your database to use UTF8 without
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
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