Char vs Varchar field types

Hi everyone, When is it appropriate to use Char instead of Varchar and vice versa? Thanks Luke mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: InnoDB tables

ys. What do you think? Regards Luke - Original Message - From: "Richard Clarke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 2:11 PM Subject: Re: InnoDB tables > Luke, > > How exactly will the foreign keys save you time? Please ex

InnoDB tables

ll foreign keys have a slow down effect? And are there any issues I need to know about before switching to InnoDB tables? Thanks in advance Luke van Blerk mysql - Before posting, please check: http://www.mysql.com/manual.php (

Re: Best field type for ID?

Thanks! Thats a great help. I didn't know that about the performance advantage. I was using INT but thought SMALLINT might be better cos it uses less space. Much obliged. - Original Message - From: "Madscientist" <[EMAIL PROTECTED]> To: "'Luke van B

Best field type for ID?

? Should one use INT instead? Regards Luke van Blerk (mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e