savaka Posted January 7, 2004 Share 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 Link to comment Share on other sites More sharing options...
section31 Posted January 7, 2004 Share 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 Link to comment Share on other sites More sharing options...
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.