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.
