Re: FW: Air pocket char fields.

From: Uwe Küchler <uwe_at_kuechler.org>
Date: Thu, 8 Dec 2011 10:43:18 +0100 (CET)
Message-ID: <55195.82.113.113.82.1323337398.squirrel_at_mx1bln1.prossl.de>

This is one of the early classics on asktom: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:123212348063

Cheers,
Uwe

--
http://oraculix.wordpress.com/


Am Mi, 7.12.2011, 22:20, schrieb rjamya:


> perhaps 'blank padding' is coming into effect?

> Raj

>

> On Wed, Dec 7, 2011 at 3:51 PM, <Joel.Patterson_at_crowley.com> wrote:

>

>>

>> I sent this to a couple DBAs, which warranted it to be posted for

>> comment.

>>

>> Do you know why this is?  Shouldn't a CHAR field size 15 return all the

>> records where the field is 15 spaces when requested?   Should it not

>> return

>> all rows if <> anything but 15 spaces?

>>

>





--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 08 2011 - 03:43:18 CST