Re: VARCHAR2: NULL value vs. empty string

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 12 Dec 2003 09:26:54 -0800
Message-ID: <1071249923.405427@yasure>

Frank wrote:

> Keith Sauvant wrote:
> 

>> Hi Group,
>>
>> is there _any_ way (Server Parameter?) to make Oracle store empty
>> strings in Varchar2s without converting them to NULL?
>>
>> Thanks in advance
>> Keith Sauvant
>>

>
> No. Oracle != MS SQL Server (And not ANSI compliant in this matter)

This has nothing to do with ANSI compliance. Where did you ever get the idea that it did?

I'd suggest you read page 38 of Tom Kyte's "Expert one-on-one Oracle."

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Dec 12 2003 - 11:26:54 CST