| query | varchar(150) | latin1_swedish_ci | | PRI | |
^^^^^^^^^^^^^^^^^
seems to disagree with
`query` varchar(150) character set latin1 NOT NULL default '',
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
^^^^^^^^^^^^^^^^^^
> -----Original Message-----
> From: Stewart Smith [mailto:stewart@stripped]
> Sent: Thursday, November 01, 2007 8:43 PM
> To: Rick James
> Cc: Kathryn Steinbrink; internals@stripped
> Subject: RE: SHOW CREATE TABLE and auto_increment
>
> On Fri, 2007-10-26 at 09:51 -0700, Rick James wrote:
> > Why does it fail to spell out collation correctly?
>
> What exactly is incorrect?
>
> > > >> mysql> show create table pageview_data;
> > > >> ...
> > > >> | pageview_data | CREATE TABLE `pageview_data` (
> > > >> `query` varchar(150) character set latin1 NOT NULL
> default '',
> > > >> `pageviews` int(11) default NULL,
> > > >> `date` varchar(10) character set latin1 default NULL,
> > > >> PRIMARY KEY (`query`)
> > > >> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
> >
> > mysql> SHOW FULL COLUMNS FROM pageview_data;
> >
> >
> +-----------+--------------+-------------------+------+-----+-
> --------+-
> > ------+------------+---------+
> > | Field | Type | Collation | Null |
> Key | Default |
> > Extra | Privileges | Comment |
> >
> +-----------+--------------+-------------------+------+-----+-
> --------+-
> > ------+------------+---------+
> > | query | varchar(150) | latin1_swedish_ci | |
> PRI | |
> > | select | | | pageviews | int(11) | NULL
> > | YES | | NULL |
> > | select | | | date | varchar(10) |
> latin1_swedish_ci
> > | YES | | NULL | | select | |
> >
> +-----------+--------------+-------------------+------+-----+-
> --------+-
> > ------+------------+---------+
>
> --
> Stewart Smith, Senior Software Engineer
> MySQL AB, www.mysql.com
> Office: +14082136540 Ext: 6616
> VoIP: 6616@stripped
> Mobile: +61 4 3 8844 332
>
> Jumpstart your cluster:
> http://www.mysql.com/consulting/packaged/cluster.html
>
