storing large integers properly

[Eben Goodman]

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]