Joel Garry wrote:
> Ed Stevens <nospam_at_noway.nohow> wrote in message news:<6l2pi0pfsptulfkmdo2t48vn9bqt153mqi_at_4ax.com>...
>
>>On Tue, 24 Aug 2004 14:21:00 -0500, Ed Stevens <nospam_at_noway.nohow>
>>wrote:
>>
>>
>>So . . . to further clarify my understanding, given a column defined
>>as CHAR(8) (fixed length, not VARCHAR -- and nulls allowed), if x'00'
>>is not a 'representation' of nulls, what is physically stored in the 8
>>bytes reserved for that column?
>
>
> This ought to be even more confusing, as it appears '' and null are
> both octal 377 followed by a newline:
>
[snip!]
The Oracle RDBMS will interpret '' as null, one of the non-ANSI
compliancies of Oracle. Looks like it's actually stored as high_values
(octal 377 being 0xff, or all 1's).
--
Regards,
Frank van Bortel
Received on Thu Aug 26 2004 - 02:45:07 CDT
