[AccessD] Number vs text data type

He did know what he was talking about.  <grin>  Numbers are only 4 bytes
(long integers).  7 'digits' with text, take up 8 bytes (one byte to
determine the length, 7 bytes for the text itself).

Drew

-----Original Message-----
From: CYNTHIA SPELL [mailto:CSPELL at jhuccp.org]
Sent: Monday, October 13, 2003 6:25 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Number vs text data type


I inherited a budget number database with the primary key being a 7-digit
number.  The data type for the field is currently number (long integer).
Since the field requires no calculation, just some sorting, I'm considering
changing the data type to text.  The budget number table links to quite a
few other databases, so I'll have to change the field in other places.  Is
there a benefit to or problem with using one or the other data type?  I
remember an instructor once saying that if there's a choice between using a
text or number type, use number since numbers sort faster than text, but I'm
not so sure he knew what he was talking about.

TIA,
Cindy Spell  


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com