Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gAC4MW712658 for ; Mon, 11 Nov 2002 22:22:32 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gAC4MVX12651 for ; Mon, 11 Nov 2002 22:22:31 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id SAA96881; Mon, 11 Nov 2002 18:03:07 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00500814; Mon, 11 Nov 2002 17:33:25 -0800 Message-ID: Date: Mon, 11 Nov 2002 17:33:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Ron/Sarah Yount Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Ron/Sarah Yount Subject: RE: Character Sets - 2 different kinds, same server Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit 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: cemail2@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@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: Ron/Sarah Yount INET: ronwy@SWBELL.NET 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@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).