From oracle-l-bounce@freelists.org Wed May 5 16:17:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45LHSs12455 for ; Wed, 5 May 2004 16:17:38 -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 i45LHI612419 for ; Wed, 5 May 2004 16:17:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E7C9072E1AB; Wed, 5 May 2004 16:07:35 -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 14867-20; Wed, 5 May 2004 16:07:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4710472DC67; Wed, 5 May 2004 16:07:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 16:06:09 -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 C946B72DF3D for ; Wed, 5 May 2004 16:06:08 -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 14194-70 for ; Wed, 5 May 2004 16:06:08 -0500 (EST) Received: from smtp-out5.xs4all.nl (smtp-out5.xs4all.nl [194.109.24.6]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2234472DCCA for ; Wed, 5 May 2004 16:06:08 -0500 (EST) Received: from dbalert99a.xs4all.nl (dbalert.xs4all.nl [213.84.185.230]) by smtp-out5.xs4all.nl (8.12.10/8.12.10) with ESMTP id i45LJvJN048008 for ; Wed, 5 May 2004 23:19:58 +0200 (CEST) Message-Id: <6.0.1.1.0.20040505231653.432b0470@pop.xs4all.nl> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Wed, 05 May 2004 23:18:50 +0200 To: oracle-l@freelists.org From: Carel-Jan Engel Subject: RE: Problem with joining char field to varchar2 field In-Reply-To: <000301c432a7$c98ffac0$0704a8c0@development.perceptron.com> References: <4001DEAF7DF9BD498B58B45051FBEA656D8496@25exch1.vicorpower.vicr.com> <000301c432a7$c98ffac0$0704a8c0@development.perceptron.com> Mime-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4521 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Warren, Can you please disclose the value of blank_trimming in both instances? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 03:49 PM 5/5/2004, you wrote: >Just checked 8.1.5 on NT and 10g on XP. >In both cases default setting for "blank_trimming" is FALSE. >But, it could be different in Warren's installation. > >Igor Neyman, OCP DBA >ineyman@perceptron.com ---------------------------------------------------------------- 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 -----------------------------------------------------------------