John W. Colby
jwcolby at colbyconsulting.com
Wed May 26 17:05:20 CDT 2004
>hmmmmmm.....who keeps bringing up internationalization issues? LOL Thanks Drew, I needed that! John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Wednesday, May 26, 2004 5:53 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various And when your database design is used in another country, with different rules.......hmmmmmm.....who keeps bringing up internationalization issues? LOL Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Wednesday, May 26, 2004 6:17 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] On DB Bloat, Bad DB Design, and various Hi John > I keep asking (and nobody is responding) - whose data is it? Whose database > is it. In most cases, the client's. > Who are YOU to TELL the client that 53 characters is all they need? I'm the expert. Quite often the client doesn't know what he/she needs. If there would be a good reason to limit a text field to 53 chars, I would tell or simply apply it. As some examples, ISO country codes are either two or three chars, BIC (SWIFT) codes are 8 or 11 chars, and IBAN codes are, by definition, max. 34 chars - anything above these numbers would represent an error and would make no sense to store. Here, no city name is longer than 20 chars and no street name is longer than 34 chars. Thus 50 is a reasonable limit for domestic address lines which, by the way, is also what Access's table designer suggests. /gustav -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com