RE: Counterquestion - is Oracle a He or a She - or an It or a hermaphrodite
- From: "Billy Verreynne (JW)" <VerreyB@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Aug 2005 13:19:08 +0200
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
//www.freelists.org/webpage/oracle-l
Other related posts:
