On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote: > > I have a MySQL database for books. The ISBN field is set as varchar(15) and > I've put a test ISBN number in of 1-1111-111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten digits, three dashes. If you really want to save space, the last digit is just a check digit and can always be determined through a formula on the other digits, so as long as you verify every ISBN before you INSERT it, you can save another digit.
Hmmm...And how do You come up with an 'X' as the last digit, as many books on the shelves around me do?
I'll snip the rest, since I agree with it all...
SQL
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]