Bug #30987 mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column

• Submitted: 12 Sep 2007 17:46
• Modified: 31 Oct 2007 19:31
• Reporter: klx out
• Status: Can't repeat
• Category: MySQL Server: Data Types
• Severity: S3 (Non-critical)
• Version: 5.0.44
• OS: Any
• CPU Architecture: Any
• Tags: warning 1366

[12 Sep 2007 17:46] klx out

Description:
I have a table with structure:

DROP TABLE IF EXISTS `syslog`;
CREATE TABLE `syslog` (
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`host` varchar(128) default NULL,
`date_logged` datetime NOT NULL default '0000-00-00 00:00:00',
`message` text,
`id` int(10) unsigned NOT NULL auto_increment,
`analized` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `analized` (`analized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

When I try to insert:

mysql> INSERT INTO syslog (date, date_logged, host, message) VALUES ('2007-02-25 23:00',
'2007-02-25 23:00', 'host', 'prova amb acc ´ FFFFFFFFFFFFFFF');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings
    -> ;
+---------+------+----------------------------------------------------------------------+
| Level   | Code | Message                                                              |
+---------+------+----------------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column 'message' at row 1 |
+---------+------+----------------------------------------------------------------------+
1 row in set (0.03 sec)

I have detected that the problem is with " ´ " char 

How to repeat:

DROP TABLE IF EXISTS `syslog`;
CREATE TABLE `syslog` (
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`host` varchar(128) default NULL,
`date_logged` datetime NOT NULL default '0000-00-00 00:00:00',
`message` text,
`id` int(10) unsigned NOT NULL auto_increment,
`analized` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `analized` (`analized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

When I try to insert:

mysql> INSERT INTO syslog (date, date_logged, host, message) VALUES ('2007-02-25 23:00',
'2007-02-25 23:00', 'host', 'prova amb acc ´ FFFFFFFFFFFFFFF');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings
    -> ;
+---------+------+----------------------------------------------------------------------+
| Level   | Code | Message                                                              |
+---------+------+----------------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column 'message' at row 1 |
+---------+------+----------------------------------------------------------------------+
1 row in set (0.03 sec)

[13 Sep 2007 15:25] MySQL Verification Team

Thank you for the bug report. I can't repeat with current source server:

mysql> CREATE TABLE `syslog` (
    -> `date` datetime NOT NULL default '0000-00-00 00:00:00',
    -> `host` varchar(128) default NULL,
    -> `date_logged` datetime NOT NULL default '0000-00-00 00:00:00',
    -> `message` text,
    -> `id` int(10) unsigned NOT NULL auto_increment,
    -> `analized` tinyint(2) NOT NULL default '0',
    -> PRIMARY KEY (`id`),
    -> UNIQUE KEY `id` (`id`),
    -> KEY `analized` (`analized`)
    -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.31 sec)

mysql> INSERT INTO syslog (date, date_logged, host, message) VALUES ('2007-02-25 23:00',
    -> '2007-02-25 23:00', 'host', 'prova amb acc ´ FFFFFFFFFFFFFFF');
Query OK, 1 row affected (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.50-nt |
+-----------+
1 row in set (0.05 sec)

[31 Oct 2007 19:31] klx out

output of SHOW VARIABLES LIKE
'char%' and SHOW VARIABLES LIKE 'coll%'  is:

*********************************

mysql> SHOW VARIABLES LIKE 'char%' and SHOW VARIABLES LIKE 'coll%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'and SHOW
VARIABLES LIKE 'coll%'' at line 1

*********************************

Also I have tried to reproduce  bug #25815  but the result its OK