Re: [stellation-res] Comments table, why insert empty comment?

[Dave Shields <shields@xxxxxxxxxxxxxx>]

On Tue, Oct 01, 2002 at 05:12:39PM +0000, Mark C. Chu-Carroll wrote:
> (It sounds to  me like the root of the problem is actually a bug in
> oracle. From the SQL stuff that I've read, it seems to be pretty 
> clear that for VARCHARs, a NULL and an empty string are two different
> things: an empty string is a string value with no characters; a NULL
> is the absense of a value.)
> 
> 	-Mark

Exactly! This does indeed look like bug in Oracle, as what happens when
the user supplies a file consisting of the empty string. I suspect this
will need to be translated to NULL in Oracle, even though the comment is
not missing.

dave

-- 
Dave Shields, IBM Research, shields@xxxxxxxxxxxxxx.