I'm using phpMyAdmin 2.5.2 (on a WinXP PC, with MySQL 4.0.12) to create a new table in a localhost database.

All of a sudden (ie. today!) I can't create CHAR type fields more than 1 char in size.

For example the following create table command APPEARS to work ok:-

CREATE TABLE `working` (
`wg_working_code` CHAR( 4 ) NOT NULL ,
`wg_working_name` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `wg_working_code` )
) TYPE = InnoDB

BUT..... afterwards the field 'wg_working_code' shows as VARCHAR(4) !?!

Any body else ever had this error?

More importantly ... anybody got the fix for it???