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
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
