Bug #22646 LC_TIME_NAMES: Assignment to non-UTF8 target fails

Description:
I tried to use French 'fr_FR' dates in an INSERT statement,
and the result was failure. The target was latin1. But the
result is utf8, as is evident using a hexadecimal display.

How to repeat:
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> create table tj (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 tj values (date_format('2004-02-02','%M'));
Query OK, 1 row affected (0.00 sec)

mysql> select hex(s1) from tj;
+------------------+
| hex(s1)          |
+------------------+
| 66C3A97672696572 |
+------------------+
1 row in set (0.00 sec)

Thank you for the bug report. Verified as described.

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/commits/15014

ChangeSet@1.2545, 2006-11-08 15:37:54+04:00, bar@mysql.com +3 -0
  Bug#22646 LC_TIME_NAMES: Assignment to non-UTF8 target fails
  Problem: After introducing of LC_TIME_NAMES variable,  the 
  function date_format() can return international non-ascii
  characters in month and weekday names. Thus, it cannot return
  a binary string anymore, because inserting a result of date_format()
  into a column with non-utf8 character set produces garbage.
  Fix: date_format() now returns a character string, using
  "collation_connection" to detect character set and collation
  for the returned value. This allows to insert
  results of date_format() properly into columns with
  various character sets.

ok to push

Pushed into 4.1.23, 5.0.36, 5.1.15

Noted in 4.1.23, 5.0.36, 5.1.15 changelogs, and modified
DATE_FORMAT() function description accordingly.

Incompatible change: Previously, the DATE_FORMAT() function returned
a binary string. Now it returns a string with a character set and
collation given by character_set_connection and collation_connection
so that it can return month and weekday names containing non-ASCII
characters.