MySQL Bugs: #16057: binary flag could not be saved successfully in the table editor

Bug #16057	binary flag could not be saved successfully in the table editor
Submitted:	29 Dec 2005 3:14	Modified:	29 Dec 2005 6:48
Reporter:	ming lu	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	1.1.5	OS:	Any (*)
Assigned to:	Aleksey Kishkin	CPU Architecture:	Any

Description:
Binary flag could not be saved successfully in the table editor.

Create a new table like this:
CREATE TABLE `db1`.`table1` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `note` VARCHAR(45) NOT NULL,
   PRIMARY KEY(`id`)
)
ENGINE = InnoDB;

Then open the table editor, set the 'note' field's flag with 'BINARY ', apply changes to save it. But when i reopen the table editor, the 'BINARY ' flag option is not be set successfully.

How to repeat:
see the description

'varchar binary' is synonym of 'varchar character set latin1 collaction latin1_bin'. (it's described in http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html ), so actually you didnt do any changes in that 'alter table'.