From oracle-l-bounce@freelists.org Mon Apr 11 11:26:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3BGQLZ9023575 for ; Mon, 11 Apr 2005 11:26:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3BGQLem023568 for ; Mon, 11 Apr 2005 11:26:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2427593FC0; Mon, 11 Apr 2005 10:24:12 -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 13970-07; Mon, 11 Apr 2005 10:24:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E27A93FBE; Mon, 11 Apr 2005 10:24:11 -0500 (EST) Message-ID: <425A9637.7010803@allegientsystems.com> Date: Mon, 11 Apr 2005 11:22:31 -0400 From: Mladen Gogala User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Paula_Stankus@doh.state.fl.us Cc: oracle-l@freelists.org Subject: Re: A question about NLS Language settings References: In-Reply-To: Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 18286 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mgogala@allegientsystems.com Precedence: normal Reply-To: mgogala@allegientsystems.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Comments inline. Paula_Stankus@doh.state.fl.us wrote: >We ran into a problem in one of our applications where the users would >cut text from a varchar2(2000) field, edit it in Word, > Paula, Microsoft is beyond ISO standards. They have their own "code page" standard which is incompatible with ISO. Microsoft double quotes need not be the same as everybody else's double quotes. Microsoft double quotes come in several colors and cost more. The mauve colored quotes take the least amount of RAM, or so I heard. >then paste it. >The problem was that certain characters like double-quotes apparently >were "unknown" in the default characterset and where stored as upside >down question marks. To get around this my colleague changed the >configuration in the application server files to: > >AMERICAN_AMERICA.WE8ISO8859P1 > > Ah, you've probably had US7ASCII before. There is a difference between 7 and 8 bit codes. In fact, there are 127 of them. >Some questions, if this is a superset for the default then why isn't it >the default? > > Because character set problems sell consulting. -- Mladen Gogala Oracle DBA Ext. 121 -- http://www.freelists.org/webpage/oracle-l