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 problems. There is a
reference to doc# 66320.1 in this document. The 66320.1 document will
explain to you how to change the character set. It worked for me in 8.1.6 on
NT.
Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 11, 2002 10:13 PM
> 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: Yechiel Adar
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).
