From oracle-l-bounce@freelists.org Wed Oct 27 12:01:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9RH1Ed00729 for ; Wed, 27 Oct 2004 12:01:14 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9RH1DI00717 for ; Wed, 27 Oct 2004 12:01:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 909D772FE04; Wed, 27 Oct 2004 12:07:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13569-42; Wed, 27 Oct 2004 12:07:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EEF7072FDC2; Wed, 27 Oct 2004 12:07:23 -0500 (EST) Message-ID: From: Janardhana Babu Donga To: "'Nelson, Allan'" , Janardhana Babu Donga , Rich.Jesse@quadtechworld.com, gsais@co.palm-beach.fl.us Cc: oracle-l@freelists.org Subject: RE: Which Character Set for 9.2 Date: Wed, 27 Oct 2004 10:05:34 -0700 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11597 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jbdonga@ucdavis.edu Precedence: normal Reply-To: jbdonga@ucdavis.edu X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dear List, If it is not required to convert from US7ASCII to WE8ISO8859P1, I don't understand why so many people are changing their character set to WE8ISO8859P1 from US7ASCII. Could some one explain please? -- Babu -----Original Message----- From: Nelson, Allan [mailto:anelson@miswaco.com] Sent: Tuesday, October 26, 2004 5:54 PM To: jbdonga@ucdavis.edu; Rich.Jesse@quadtechworld.com; gsais@co.palm-beach.fl.us Cc: oracle-l@freelists.org Subject: RE: Which Character Set for 9.2 No. US7ASCII is a strict subset of WE8ISO8859P1. This means that not only is every symbol defined in US7ASCII also in WE8ISO8859P1 but that these symbols are in the same entries in the respective symbol tables. That's as good as it gets. Allan -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Janardhana Babu Donga Sent: Tuesday, October 26, 2004 4:27 PM To: 'Rich.Jesse@quadtechworld.com'; gsais@co.palm-beach.fl.us Cc: oracle-l@freelists.org Subject: RE: Which Character Set for 9.2 I too am planning to convert from US7ASCII to WE8ISO8859P1. I am moving the databases from HP boxes to Sun Solaris Systems. I am using Exp/Imp to migrate. Old DB has US7ASCII character set. New DB will be created in WE8ISO8859P1. I would like to know if the above character set conversion is required? Any help is appreciated. -- Babu -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jesse, Rich Sent: Tuesday, October 26, 2004 11:55 AM To: gsais@co.palm-beach.fl.us Cc: oracle-l@freelists.org Subject: RE: Which Character Set for 9.2 I completely forgot about the "csscan" utility -- it should give you an = idea of how much work you're in for. Of course, it's probably best to run this on a recent complete copy of = your DB, if possible... Rich -----Original Message----- From: oracle-l-bounce@freelists.org Sent: Tuesday, October 26, 2004 12:55 PM Subject: RE: Which Character Set for 9.2 Yeah, amen, etc. We took finaancials at 11.5.7 to utf-8 and we had a lot of data, principally from Russia, that had already been put into non-utf-8 compliant homebrew software. Boy was it fun to migrate that stuff! Allan -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l ____________________________________________________________________________ __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- http://www.freelists.org/webpage/oracle-l