Bug #23460 Cut out insert query

• Submitted: 19 Oct 2006 11:39
• Modified: 20 Oct 2006 15:11
• Reporter: Maxim Pomazan
• Status: Not a Bug
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 5.0.22,5.0.26
• OS: Linux (Fedora Core 4)
• CPU Architecture: Any
• Tags: character set

[19 Oct 2006 11:39] Maxim Pomazan

Description:
The line with symbols 92,93(’,‘) and many other from win1252 (latin1) cut out line when executing insert query.

How to repeat:
At first:
My PuTTY win1252 codding

mysql> show variables like '%character_set_%';
+--------------------------+---------------------------------------+
| Variable_name            | Value                                 |
+--------------------------+---------------------------------------+
| character_set_client     | utf8                                  |
| character_set_connection | utf8                                  |
| character_set_database   | utf8                                  |
| character_set_filesystem | binary                                |
| character_set_results    | utf8                                  |
| character_set_server     | latin1                                |
| character_set_system     | utf8                                  |
| character_sets_dir       | /virtual/mysql5/share/mysql/charsets/ |
+--------------------------+---------------------------------------+
8 rows in set (0.02 sec)

mysql> show create table test;
+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table            | Create Table                                                                                                                                                      |
+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test | CREATE TABLE `test` (
  `id` int(16) NOT NULL default '0',
  `body` text,
  `encoding` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> insert into test (id,body) values (-7,"tatata with “’’’’’ ‘’’’’’ ‘’ ‘ ‘’’’’’’’ ‘ ‘ ‘’end of string");
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * test where id in (-7);
+----+--------------+
| id | body         |
+----+--------------+
| -7 | tatata with  |
+----+--------------+
1 row in set (0.42 sec)

That`s all! Where other symbols??? No Error or Warning. Query OK!

[19 Oct 2006 12:08] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 5.0.26. Note also that there was a warning in your case. Please, check exact text with SHOW WARNINGS\G after INSERT.

[20 Oct 2006 13:11] Maxim Pomazan

In 5.0.26 version this problem is not resolved. Our site in utf8 but 50-100 peoples using cp1252 and all records with ” and ’ are truncated.

[20 Oct 2006 15:11] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Read about character_set_client at http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html