Bug #29128 LC_TIME_NAMES=fr_FR, assignment to non-UTF8 target fails with MONTHNAME()
| Submitted: | 15 Jun 2007 5:28 | Modified: | 27 Feb 2009 5:30 |
|---|---|---|---|
| Reporter: | Alexander Barkov | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
| Version: | 5.0, 5.1, 4.1 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[15 Jun 2007 6:53]
Sveta Smirnova
Thank you for the report. Verified as described.
[23 Nov 2007 6:31]
Alexander Barkov
This bug should be fixed at the same time: Bug #14368 UPPER and LOWER functions don't work with DAYNAME
[27 Feb 2009 5:30]
Alexander Barkov
Duplicate for Bug#37575
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: mysql> drop table if exists t1; Query OK, 0 rows affected (0.00 sec) mysql> set names utf8; Query OK, 0 rows affected (0.00 sec) mysql> create table t1(s1 char(20) character set latin1); Query OK, 0 rows affected (0.00 sec) mysql> set LC_TIME_NAMES = 'fr_FR'; Query OK, 0 rows affected (0.00 sec) mysql> insert into t1 values (monthname('2004-02-02')); Query OK, 1 row affected (0.00 sec) mysql> select hex(s1) from t1; +------------------+ | hex(s1) | +------------------+ | 66C3A97672696572 | +------------------+ 1 row in set (0.00 sec) February in French is "février". The second letter is "SMALL LETTER E WITH ACUTE ABOVE". It's latin1 code is 0xE9. The result is wrong: 66 + C3A9 + 7672696572 The correct result should be: 66 + E9 + 7672696572 Conversion from utf8 to latin1 didn't happen. The same problem happends with DAYNAME(): mysql> set lc_time_names=sv_SE; Query OK, 0 rows affected (0.00 sec) mysql> select dayname('2004-02-01'); +-----------------------+ | dayname('2004-02-01') | +-----------------------+ | söndag | +-----------------------+ 1 row in set (0.00 sec) mysql> insert into t1 values (dayname('2004-02-01')); Query OK, 1 row affected (0.00 sec) mysql> select hex(s1) from t1; +----------------+ | hex(s1) | +----------------+ | 73C3B66E646167 | +----------------+ 1 row in set (0.00 sec) The above result is wrong again. The correct result should be: 73 + F6 + 6E646167 where 0xF6 is latin1 code for "SMALL LETTER O WITH DIAERESIS". How to repeat: Run the above tests. Suggested fix: Monthname() and Dayname() must be converted to the target character set.