savaka Posted January 7, 2004 Posted January 7, 2004 I am working on building my first ever mySql database. It is a simple one, listing a collection of books. I have created for the first table a number of fields for title, author, isbn, etc. What I would like to know is what is the type I should enter for the ISBN number. Should I use INT? TEXT? The format of my ISBN numbers will be like this: 1-885419-54-0 Suggestions? Thanks. Quote
section31 Posted January 7, 2004 Posted January 7, 2004 INT is out of the question since your going to have dashes. I would use char(length) or varchar(length) since its going to be a fixed number of characters. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.