[AccessD] Number vs text data type

CYNTHIA SPELL CSPELL at jhuccp.org
Mon Oct 13 06:44:46 CDT 2003


Thanks, Gustav!

>>> gustav at cactus.dk 10/13/03 07:36AM >>>
Hi CYNTHIA

> 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.

He did.

With no good reason for the change, I would spend my time on more
interesting tasks!

/gustav

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



More information about the AccessD mailing list