On 5 Aug 2003 at 9:49, Eben Goodman wrote: > 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?
Yes. Phone numbers, zip codes, Social Security numbers, etc., are generally stored as strings, not integers, since they can have leading 0s and you're not going to do calculations on them. Besides, don't some ISBNs end in 'X'? -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
