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, 2004 10:01 AM
Subject: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion
from `char` TO `varchar`)
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 length fields, the table will be static. But when you
add
just one field of variable length, the table will be dynamic.
Therefore, I tried to move any i.e. varchar type fields to char, but the
type of the
table does not change when I am using the ALTER statement. Right now, I only
can do
this conversion by dumping data and structure, removing the table, changing
the fields
and then inserting structure and data again.
* Is there another way to do this ?
* Has anybody ever had to rebuild a corrupted table, and is rebuiling a
static table
really easier for software than rebuilding a dynamic one?
Greetinx,
Chris
SZM Studios *
Dipl.Ing. Christian Merten * Ingenieur Broadcast-Support
Oberwallstraße 6 * 10117 Berlin
Tel. [030] 2090-3167 * Fax [030] 2090-3092
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
<http://www.szm-studios.de>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
