From oracle-l-bounce@freelists.org Wed May 5 08:40:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45De9p08484 for ; Wed, 5 May 2004 08:40:19 -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 i45Ddw608416 for ; Wed, 5 May 2004 08:40:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ADB1F72D116; Wed, 5 May 2004 08:30:05 -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 26194-41; Wed, 5 May 2004 08:30:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09DCD72D131; Wed, 5 May 2004 08:30:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 08:28:50 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D13872D0CB for ; Wed, 5 May 2004 08:28:50 -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 26099-28 for ; Wed, 5 May 2004 08:28:50 -0500 (EST) Received: from mail.sagelogix.com (unknown [69.15.85.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 058E872D0B8 for ; Wed, 5 May 2004 08:28:50 -0500 (EST) Received: by mail.sagelogix.com (Postfix, from userid 70101) id 4943931793; Wed, 5 May 2004 07:30:58 -0600 (MDT) Received: from ocs.sagelogix.com (ocs.sagelogix.com [192.168.25.20]) by mail.sagelogix.com (Postfix) with ESMTP id 6C78B31794 for ; Wed, 5 May 2004 07:30:50 -0600 (MDT) Received: from 0-2pool82-55.nas33.thornton1.co.us.da.qwest.net by ocs.sagelogix.com with ESMTP id 1356671083760139; Wed, 05 May 2004 06:28:59 -0600 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Wed, 05 May 2004 07:42:30 -0600 Subject: Re: Problem with joining char field to varchar2 field From: Tim Gorman To: Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=2.3 tests=BAYES_00 autolearn=ham version=2.63 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4428 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim@sagelogix.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Sorry, I should have thrown a "smiley" after the comment about the "bug" in ANSI SQL; it was a response directed to the question about whether the cause was a bug in Oracle or a bug in AIX... As you can tell, I see the CHAR and NCHAR datatypes as problems to be eradicated... :-) on 5/5/04 3:31 AM, Natural Join B.V. at lex.de.haan@naturaljoin.nl wrote: > Hi Tim, > > allow me to elaborate a little here. > if you are referring to what I think you are referring to, this is not an > ANSI/ISO bug but rather a feature ;-) > > it is not a matter of what you are physically storing in your database, but > rather a matter of comparison semantics when dealing with strings of different > lengths -- the two options are: padded vs non-padded semantics. > > Cheers, > Lex. > > PS: adding leading zero's to a numeric attribute does not change its value; > adding trailing spaces to an alphanumeric attribute DOES change its value. > >> Warren, >> >> This is a bug with the ANSI SQL standard. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------