<ensembl,
Thursday, April 11, 2002, 6:18:04 AM, you wrote:
e> Description:
e> When attempting to modify a column from varchar(40) to char(40) the command
returns successfully, however the table is unaltered
e> How-To-Repeat:
e> (prepare a table table_name with a column column_name varchar(40)
e> alter table table_name modify column_name char(40) NOT NULL default '';
e> describe table_name
e> Fix:
e> alternative right now is to drop the table and recreate it
What is the structure of your table?
In some cases MySQL changes column specification. If your table have
any variable-length column, all your CHAR columns that are longer than
3 characters are changed to VARCHAR columns. Look at:
http://www.mysql.com/doc/S/i/Silent_column_changes.html
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
