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<br /><br />Suggestions? Thanks. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /><!--content-->
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.<!--content-->
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.<!--content-->