Re: Character Sets - 2 different kinds, same server

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 <ORACLE-L_at_fatcity.com> 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: cemail2_at_sprintmail.com
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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).