MySQL Forums
Forum List  »  Federated Storage Engine

Select utf8 data from federated table
Posted by: Aida Jamak
Date: March 02, 2007 07:11AM

I have a federated and master table:

CREATE TABLE `federated_table` (
...
`something` varchar(30) NOT NULL,
...
PRIMARY KEY (`id`)
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CONNECTION='mysql://user:pass@hostname/db/master_table';

CREATE TABLE `master_table` (
...
`something` varchar(30) NOT NULL,
...
PRIMARY KEY (`id`)
) ENGINE=MyISam DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

When I do a select on a master table, records in column `something`, that contain 'š' and 'ž' are returned OK (whole records).

But, when I do the same select on a federated table, records in `something` are truncated before 'š' and 'ž'. If those characters are in the middle of the word, it is possible to guess what is the content, but if they are the first characters, then empty string is returned.

Show variables like 'char%' gives the same results on both hosts.

Is this a bug in federated engine? Does it work OK with utf8?

Please, help me out, I really need this!

Options: ReplyQuote


Subject
Views
Written By
Posted
Select utf8 data from federated table
7762
March 02, 2007 07:11AM


Sorry, you can't reply to this topic. It has been closed.

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.