Sunday, September 28, 2008

sql defaults

Just a note to say I am editing the tables after they are created. I am using phpmyadmin to do my sql and the defaults are for InnoDB and latin_swedish_ci. So I am changing them to MyISAM and latin_general_ci. You could do this in the CREATE TABLE command but i forgot, and maybe most of you already have these as your defaults anyway so I won't refer to this again but make sure your defaults are as mine.

Actually InnoDB may be a better choice of table for this app, due to the transactional nature of the app, but for now I am sticking with what I know. Any thoughts on the Falcon engine?

No comments: