It might depend on the other columns in your table definition. Have you looked at the Silent Column Specification Changes? http://www.mysql.com/doc/S/i/Silent_column_changes.html If you have ANY varchar() columns, all char columns greater than three characters are changed to varchar(). Perhaps the 'little play table' doesn't have any other varchars... On Wed, 1 Aug 2001, Lezz Giles wrote: > I'm running 3.21.33b (yes, I know it's old), and I run the command: > > alter table branch change codebase codebase char(32) not null default > "IPriori"; > > where column codebase has type varchar(32) - but the type does not change to > char(32). > There's no error message or other indication of what went wrong, and if I create > > a little play table I can succesfully change the column type to char(32) from > varchar(32). > The table "branch" has just 180 rows in it. > > I'd like to change the column types from varchar to char to speed up queries & > etc. > Can anybody shed any light on what I'm doing wrong? > > Thanks, > Lezz Giles --------------------------------------------------------------------- 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