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

[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] MySQL Verification Team
Thank you for the bug report. Verified as described.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 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.