Bug #27138 SHOW CREATE TABLE result has BINARY_FLAG set

• Submitted: 14 Mar 2007 15:57
• Modified: 27 Mar 2007 9:29
• Reporter: Bogdan Degtyariov
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Any
• CPU Architecture: Any
• Tags: BINARY_FLAG, mysql_fetch_field, SHOW CREATE TABLE

[14 Mar 2007 15:57] Bogdan Degtyariov

Description:
"SHOW CREATE TABLE my_table" result columns have BINARY_FLAG set. This looks irrelevant.

How to repeat:
Just create any table. For instance:
CREATE TABLE `mytable` (
  `id` int(11) NOT NULL auto_increment,
  `mytext` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
);

Run the C test case below.

[14 Mar 2007 15:58] Bogdan Degtyariov

C test case

Attachment: binary_flag_test.c (text/plain), 2.51 KiB.

[27 Mar 2007 9:29] Tonci Grgin

This is a duplicate of Bug#10491.

[3 Apr 2007 23:08] Jared S

Please give full database version.