Bug #15478 Insert/Edit rows does not respect

• Submitted: 5 Dec 2005 9:39
• Modified: 19 Jun 2006 19:40
• Reporter: Silvan Mühlemann
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.17
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[5 Dec 2005 9:39] Silvan Mühlemann

Description:
In Version 1.1.17, when you edit/insert a row with international-non-ASCII-Characters QB does not respect the character set defined in character_set but users UTF-8. 

In 1.1.14 this bug is not there.

How to repeat:
mysql> show variables like "character_set";
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| character_set | latin1 |
+---------------+--------+
1 row in set (0.00 sec)

mysql> create table test(myid int not null auto_increment primary key, myrow char(100));
Query OK, 0 rows affected (0.34 sec)

// insert internationals characters with 1.1.14

mysql> select * from test;
+------+--------+
| myid | myrow  |
+------+--------+
|    1 | äöüàéè |
+------+--------+
1 row in set (0.00 sec)

// insert international characters with 1.1.17

mysql> select * from test;
+------+--------------+
| myid | myrow        |
+------+--------------+
|    1 | äöüàéè       |
|    2 | äöüà éè |
+------+--------------+
2 rows in set (0.00 sec)

[5 Dec 2005 9:53] Valeriy Kravchuk

Thank you for a problem report. Please, send the results of the

show variables like 'character_set%'

statement from the QB 1.1.17 you used to insert that row for a second time.

[5 Dec 2005 10:07] Silvan Mühlemann

+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name  | Value                                                                                                                                                                                                             |
+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| character_set  | latin1                                                                                                                                                                                                            |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[5 Dec 2005 10:13] Valeriy Kravchuk

Looks like your results are from mysql client, not form the Query Browser, as I asked. 

What version of MySQL server are you connecting to?

[5 Dec 2005 10:38] Silvan Mühlemann

Here's the Output from QB 1.1.17 as CSV:

"Variable_name","Value"
"character_set","latin1"
"character_sets","latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5"

[5 Dec 2005 10:42] Silvan Mühlemann

[root@fiona root]# /usr/sbin/mysqld -V
/usr/sbin/mysqld  Ver 4.0.25-standard-log for pc-linux-gnu on i686 (Official MySQL RPM)

[5 Dec 2005 10:54] Vasily Kishkin

You need to set right character set  for internationals characters. Read please:
http://dev.mysql.com/doc/refman/4.1/en/charset-table.html. Could you please create table with right character set  and try more ?

[6 Jan 2006 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[19 May 2006 19:40] Valeriy Kravchuk

In case Vasili's advice had not helped, please, try to repeat with a newer version, 1.1.20, and inform about the results.

[19 Jun 2006 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".