Bug #25707 Federated: CREATE SERVER database names with non-Latin characters
Submitted: 18 Jan 2007 22:10 Modified: 5 Nov 2009 12:53
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S4 (Feature request)
Version:5.1.15-beta-debug-log OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: CPU Architecture:Any

[18 Jan 2007 22:10] Peter Gulutzan
Description:
In CREATE SERVER, allow use of database names containing
characters outside the usual range. Currently the syntax
is okay but the connection fails.

How to repeat:
I have a database on the local machine named ペ (the character here is U+30DA).
In the database there is a table named t100.

On the remote machine, I say:

CREATE SERVER ペ FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'Remote', HOST '192.168.1.106', DATABASE 'ペ');

CREATE TABLE t100 (s1 INT) ENGINE=FEDERATED CONNECTION='ペ';

I see the message:
ERROR 1429 (HY000): Unable to connect to foreign data-source:
database: 'ペ' username: 'Remote' Hostname: '192.168.1.106'

I am confident that the refusal is due to the name, because
if I say "RENAME DATABASE ペ TO d" on the local, and then
say "CREATE SERVER ... DATABASE 'd' ..." on the remote, and
then CREATE TABLE again, the connection works.