Re: SQL Humor

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 - 22:04:30 CEST