Hi Well I searched the web for answers first but there is so much its hard to know were to start
I'm creating a Genealogical Database and want to start right and ensure my basic table and fields are correct (I see that I can a large variety of table types) My data is made of Names, Dates and occasionally images. From the web side the vast majority of queries will be made on the surname so I'm thinking that I should create a full text index on the surname field ? as that will enable fast searching on the field ? Any advice on what field types I should use for names \ dates and Images would be appreciated - oh and table type. Regards John --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
