Bug #27138 SHOW CREATE TABLE result has BINARY_FLAG set
Submitted: 14 Mar 2007 16:57 Modified: 27 Mar 2007 11:29
Reporter: Bogdan Degtyariov
Status: Duplicate
Category:Server Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Target Version:
Tags: mysql_fetch_field, BINARY_FLAG, SHOW CREATE TABLE

[14 Mar 2007 16: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 16:58] Bogdan Degtyariov 
C test case

Attachment: binary_flag_test.c (text/plain), 2.51 KiB.
[27 Mar 2007 11:29] Tonci Grgin 
This is a duplicate of Bug#10491.
[4 Apr 2007 1:08] Jared Sullivan 
Please give full database version.