I usually us MyISAM but you should read the description of each in the mysql manual to determine what is best for you.. same thing about the checkboxes..
----- Original Message ----- From: "FlashGuy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 11:16 AM Subject: OT: CF and mySQL (configuring) > OK...I'm getting there. I have the service running. I've created my database and table with MySQL-Front. I'm in the process of creating the fields but I'm stuck on what type > from the Field-Properties, Length/Set and Default Value to select. > > Also Table-Type? > > Options are: > Automatic (by default) > ISAM > MyISAM > HEAP > MERGE > InnoDB > BDB > > These are the fields from my access database: > > ID (automatically generated by Access) Do I include this field when I "import" the comma-delimited file exported from Access? > field1 (text. Could be 5-20 characters long) > field2 (text. This field is updated from another database. It will be a comma-delimited string from 5 to possibly 1000+ characters) > > There are also other boxes to check: > > [ ] Primary > [ ] Index > [ ] Unique > [ ] Unsigned (This was checked by default) > [ ] Zerofil > [ ] Not Full > [ ] AutoIncrement > > How do I proceed? > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
