Thijs Kinkhorst wrote:
On Wednesday 6 February 2008 18:11, Olaf van der Spek wrote:
CREATE TABLE `xbt_torrents` (
`tid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`info_hash` binary(20) NOT NULL,
PRIMARY KEY (`tid`),
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
This definition has a spurious "," after the primary key.
Yes, unfortunately MySQL doesn't like that. :(
I tried to reproduce it both in 4:2.9.1.1-6 and 4:2.11.5-1, but cannot
reproduce the described behaviour. Do you have a number of steps that
reproduce it reliably for you?
Hmm, no.
phpMyAdmin does show queries like
UPDATE `t` SET `f` = '<><' WHERE CONVERT( `t`.`f` USING utf8 )
= '<�������������������' LIMIT 1 ;
But the actual query appears to be fine, it's just the output to the
browser that's wrong.
I use the Insert tab to insert the character '<'.
Greetings
Olaf
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
