RE: Counterquestion - is Oracle a He or a She - or an It or a hermaphrodite

Nuno Souto wrote:

> The dreaded "%00".

Noons, the real problem here is that this is a null character - which means here null is given a value. Akin to having a character symbol for inifinity (supported by some fonts). The fact however remains that this is a character value and not a state. Which is why CHR(0) = CHR(0), CHR(0) != NULL, NULL != NULL, and NULL is NULL.

> Which wreaks havoc with string lengths and should be
> *BANNED* from ALL URLs in the whole wide world! (rant/)

Who introduced zero terminated strings? The dimwits who designed the C language, not? :-)

*That* is the problem. Pascal has a much better and cleaner solution as it stores the actual string size in the zero char position (though the physical implementation has changed slightly with 2GB string support).

Anyway, this means that in Pascal/Delphi a string can happily contain #0's. Which again proves that Delphi rules and C/C++ is simply uncool. ;-)

--
Billy
PS. Did you watch the Tri-Nation's opening game? Lots of relief here
that we managed to beat the Wallabies. :-)


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
http://www.freelists.org/webpage/oracle-l