Eben. Yes, use a character based data type as the leading zero's are insignificant and will be removed.
HTH Kev. > ---------- > From: Eben Goodman > Sent: Tuesday, August 5, 2003 14:49 PM > To: [EMAIL PROTECTED] > Subject: storing large integers properly > > I am storing book isbn numbers in a table. isbn numbers are 10 digit > numbers and many start with 0. The data type of the field I am storing > this info in is a bigint(16) unsigned. It appears that isbns that start > with 0 are going in as 9 digit numbers, the 0 is being ignored or > stripped. I have experienced this before with integer data types > ignoring leading 0s. I'm wondering how to address this? Should I > change the field to a varchar or char data type? > > Any advice is appreciated, > > thanks, > Eben > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star Internet. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > E-MAIL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. All information provided, including but not limited to, quotations, system specifications and suggestions concerning hardware/software (and services) configurations are strictly subject to our standard terms and conditions of business, copies of which are available on request. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]