Bug #12600 Inserting into LONGTEXT gives strange error message
Submitted: 16 Aug 2005 14:30 Modified: 14 Sep 2005 15:42
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.12 OS:Linux (Linux)
Assigned to: Alexander Barkov
Triage: D5 (Feature request)

[16 Aug 2005 14:30] Hakan Küçükyılmaz
Description:
Inserting into LONGTEXT gives strange error message if field is set to utf8.

How to repeat:
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a longtext);
INSERT INTO t1 VALUES (0xef87b1f48fbfbff0908080c3bcd098e4b880ec9a81);

ALTER TABLE t1 MODIFY a longtext character set utf8;
INSERT INTO t1 VALUES (0xef87b1f48fbfbff0908080c3bcd098e4b880ec9a81);

5.0.12-beta-debug-log
[16:08] root@test>INSERT INTO t1 VALUES (0xef87b1f48fbfbff0908080c3bcd098e4b880ec9a81);
ERROR 1406 (22001): Data too long for column 'a' at row 1
[16 Aug 2005 14:31] Hakan Küçükyılmaz
SQL mode is
sql_mode="ANSI_QUOTES,NO_BACKSLASH_ESCAPES,TRADITIONAL,IGNORE_SPACE"
[16 Aug 2005 15:25] Miguel Solorzano
mysql> INSERT INTO t1 VALUES (0xef87b1f48fbfbff0908080c3bcd098e4b880ec9a81);
ERROR 1406 (22001): Data too long for column 'a' at row 1
[17 Aug 2005 1:27] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28363
[29 Aug 2005 10:43] Alexander Barkov
Duplicate with bug#9337