Bug #25509 Federated: Failure with non-ASCII characters

• Submitted: 10 Jan 2007 0:56
• Modified: 11 Jan 2007 10:10
• Reporter: Peter Gulutzan
• Status: Verified
• Category: Server: Federated
• Severity: S3 (Non-critical)
• Version: 5.2.0
• OS: Linux (SUSE 10.0 / 64-bit)
• Triage: Triaged: D2 (Serious)

[10 Jan 2007 0: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 3:16] Miguel Solorzano

Thank you for the bug report. Verified as described.