Cannot change column type from varchar(32) to char(32)

[Lezz Giles]

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



--
Leslie Giles               Software Release Manager           Avici Systems Inc
lgiles@stripped             Phone: [phone]              Fax: [phone]

                            "Do not fear the merge"