astralaaron Posted May 13, 2007 Share Posted May 13, 2007 ENGINE=MyISAM DEFAULT CHARSET=latin1can someone explain to me what MyISAM is?also what the CHARSET=latin1 is? Link to comment Share on other sites More sharing options...
MildewMan1 Posted May 13, 2007 Share Posted May 13, 2007 MyISAM is a type of table. It's the default table type in MySQL now used over the deprecated ISAM tables. ISAM tables do not allow NULL values in indexed columns. These are just your basic ordinary MySQL tables.I'm not sure what the charset does, but if I had to guess, I would say it recognizes characters used in the latin language. A good charset to use is UTF-8, so that a page works no matter the language (as latin1 does not support Chinese)...That's just my guess though. Link to comment Share on other sites More sharing options...
astralaaron Posted May 13, 2007 Author Share Posted May 13, 2007 thanks.. so if that is the default do I even need to put part of the code in? Link to comment Share on other sites More sharing options...
MildewMan1 Posted May 13, 2007 Share Posted May 13, 2007 all the code I have ever seen still indicates that it is MyISAM. I suppose this is just in case someone tries to load it with an older version of MySQL or something.A couple of books I recommend getting that are pretty helpful are "MySQL Cookbook (ISBN = 0596001452)" and "PHP Cookbook (ISBN = 0596101015)". They are both published by O'Reilly Books. You can probably buy them pretty cheap on Half.com or something. They give a lot of good examples to help out with code creation. Link to comment Share on other sites More sharing options...
astralaaron Posted May 14, 2007 Author Share Posted May 14, 2007 all the code I have ever seen still indicates that it is MyISAM. I suppose this is just in case someone tries to load it with an older version of MySQL or something.A couple of books I recommend getting that are pretty helpful are "MySQL Cookbook (ISBN = 0596001452)" and "PHP Cookbook (ISBN = 0596101015)". They are both published by O'Reilly Books. You can probably buy them pretty cheap on Half.com or something. They give a lot of good examples to help out with code creation.cool, thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.