Re: SQL Humor
From: Paul <paul_at_test.com>
Date: Fri, 26 Aug 2005 12:56:25 +0100
Message-ID: <430f05fb$0$97094$ed2619ec_at_ptn-nntp-reader03.plus.net>
Date: Fri, 26 Aug 2005 12:56:25 +0100
Message-ID: <430f05fb$0$97094$ed2619ec_at_ptn-nntp-reader03.plus.net>
rchrismon_at_patmedia.net wrote:
> Joe, I use char(9) and a minimal constraint. And a good front end
> developer will do things there to ensure only digits and do formatting
> and stuff. But the first question I'm wondering about is running out of
> space. I suppose the feds could go alpha-numeric; that would nearly
> quadruple the available identifiers without changing the length of the
> field, but it's still a bandaid. Shouldn't a "good DB designer" be
> wondering abou that "9" in the field definition?
It would be fairly straightforward to change it to a char(10) in the future if necessary, wouldn't it?
Paul. Received on Fri Aug 26 2005 - 13:56:25 CEST