Re: SQL Humor

From: Gene Wirchenko <>
Date: Fri, 19 Aug 2005 12:00:15 -0700
Message-ID: <>

On 19 Aug 2005 10:22:41 -0700, "AK" <AK_TIREDOFSPAM_at_hotmail.COM> wrote:

>>> You have varchar2 limited to 4000 bytes.
>Then you have text to cover 4K to 2G range. Then you have to rely on
>some other option to be able store data bigger than 2G (split it into
>chunks in your application????).
>If you suggested such a design to programmic language community, you
>would be laughed at.
>oh really? then how comes C# has 8 types to store integers only, not
>counting decimal type? Is it funny too?

     Is there anything different between a string 4096 long and a string 4097 long? Are there any different machine instructions that are required to handle them? No?

     What about with integers? Yes?

     There is your difference.

>>> In fact, those ugly length
>limited datatypes are just artifacts of the early SQL days,
>on the contrary, it is a very powerful tool in enforsing data integrity

     Oh? How? Data values have very little to do the difference between 4096 and 4097 long strings.


Gene Wirchenko Received on Fri Aug 19 2005 - 21:00:15 CEST

Original text of this message