Bug #12829 Cannot convert the charset of a GROUP_CONCAT result

• Submitted: 26 Aug 2005 11:05
• Modified: 8 Sep 2005 20:29
• Reporter: Hervé Guillemet
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.14
• OS: Linux (Linux)
• Assigned to: Alexander Barkov
• CPU Architecture: Any

[26 Aug 2005 11:05] Hervé Guillemet

Description:
After change the character set undestood by the client with SET CHARACTER SET,
GROUP_CONCAT results are not converted.

How to repeat:
<pre>
CREATE TEMPORARY TABLE tmp (t CHAR(10));
INSERT INTO tmp VALUES ('éé');

SET CHARACTER SET 'utf8';
SELECT t FROM tmp;
+------+
| t    |
+------+
| éé |
+------+

SELECT GROUP_CONCAT(t) FROM tmp;
+-----------------+
| group_concat(t) |
+-----------------+
| éé              |
+-----------------+

</pre>

[26 Aug 2005 19:14] MySQL Verification Team

mysql> CREATE TABLE tmp (t CHAR(10));
Query OK, 0 rows affected (0.04 sec)

mysql> INSERT INTO tmp VALUES ('éé');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT t FROM tmp;
+------+
| t    |
+------+
| éé   |
+------+
1 row in set (0.01 sec)

mysql> SET CHARACTER SET 'utf8';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT t FROM tmp;
+------+
| t    |
+------+
| éé |
+------+
1 row in set (0.00 sec)

mysql> SELECT GROUP_CONCAT(t) FROM tmp;
+-----------------+
| GROUP_CONCAT(t) |
+-----------------+
| éé              |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT t FROM tmp;
+------+
| t    |
+------+
| éé |
+------+
1 row in set (0.00 sec)

mysql> select version();
+------------------+
| version()        |
+------------------+
| 4.1.15-debug-log |
+------------------+
1 row in set (0.00 sec)

[30 Aug 2005 10:40] 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/29025

[7 Sep 2005 11:27] Alexander Barkov

Pushed into 4.1.15 and 5.0.13

[8 Sep 2005 20:29] Paul DuBois

Noted in 4.1.15, 5.0.13 changelogs.