Re: SQL Humor

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Fri, 19 Aug 2005 13:04:30 -0700
Message-ID: <7eecg1ln5ontqdedj1p7jht8ksbq4a84ld@4ax.com>

On 19 Aug 2005 12:31:15 -0700, "AK" <AK_TIREDOFSPAM_at_hotmail.COM> wrote:

[??? wrote:]
>>>> In fact, those ugly length
>>limited datatypes are just artifacts of the early SQL days,

[AK wrote:]

>>on the contrary, it is a very powerful tool in enforsing data integrity

[Gene Wirchenko wrote:]

> Oh? How?

>by declaring STATE_CODE CHAR(2) I don't let old style abbreviations
>'Fla' and 'Ill' in
>
>by declaring COUNTRY_CODE CHAR(3), etc.

True, but that was not the point. The point was that datatypes limited to arbirary characters are artifacts. (Note: "datatypes" not "columns". Your usage is good.)

(Please do not strip attributions when you quote someone.)

Sincerely,

Gene Wirchenko Received on Fri Aug 19 2005 - 15:04:30 CDT