Bug #25509 Federated: Failure with non-ASCII characters
Submitted: 9 Jan 2007 23:56 Modified: 11 Jan 2007 9:10
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:5.2.0 OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: CPU Architecture:Any
Triage: Triaged: D2 (Serious)

[9 Jan 2007 23:56] Peter Gulutzan
Description:
On a remote computer, I create a table with a Unicode column.
On a local computer, I create a matching federated table.
I try to insert a string with special characters.
I fail.

See also forum posting: "cp1251 codepage problem in federated tables" http://forums.mysql.com/read.php?105,127944,127944#msg-127944

This bug report was inspired by a suggestion from Brian Aker.

How to repeat:
On the remote computer, say:
  USE test;
  SET NAMES UTF8;
  CREATE TABLE t1 (s1 CHAR(5) CHARACTER SET UCS2);
  INSERT INTO t1 VALUES ('AÁÑ');

On the local computer, say:
  USE test;
  SET NAMES UTF8;
  create table t1 (s1 char(5) character set ucs2)
  ENGINE=FEDERATED
  CONNECTION='mysql://Remote@192.168.1.106/test/t1';
  /* Change User and Host to what's appropriate for you. */
  INSERT INTO t1 VALUES ('AÁÑ');
  SELECT * FROM t1;

The result of the final SELECT will not contain 'AÁÑ'.
[10 Jan 2007 2:16] Miguel Solorzano
Thank you for the bug report. Verified as described.