Re: between '' and 'ZZZ'

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/03/31
Message-ID: <38E4D304.813B8A05@edcmail.cr.usgs.gov>#1/1

> That would mean oracle can not handle empty strings?
> As far as I know '' is an empty string wich is different from
> NULL wich is undefined, unknown etc.etc.

Oracle's current take is that '' is the empty string which is not the same as NULL. But the new SQL standard being discussed will equate the empty string with NULL. Oracle has said that they will "honor" this change should the standards body agree.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Mar 31 2000 - 00:00:00 CST