Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

2004-02-09 Thread Merten Christian
As to the discussion about char vs. varchar fields, I am now into a problem which is near by the above one: We are about to design a new database with high importance to stability and crash recovery. So I found, that two types of MyISAM tables exist (static and dynamic). If you have only fixed

Re: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

2004-02-09 Thread Jocelyn Fournier
Hi, If all your fields have a fixed length, you can change the type of the table by doing : ALTER TABLE your_table ROW_FORMAT=fixed; Regards, Jocelyn - Original Message - From: Merten Christian [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 09,