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]
