Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.15
-
None
-
Windows 7
Description
Having done on the remote server:
create table t1 (line char(32) character set UTF8 not null) engine=myisam;
|
insert into t1 values('Et si on était déjà à noël ?');
|
select * from t1;
|
returns:
line |
---|
Et si on était déjà à noël ? |
On the local server, a FEDERATED table to access it can be created as:
create table t1 engine=FEDERATED
|
connection='mysql://root:tinono@localhost:3307/test/t1';
|
select * from t1;
|
returns:
line |
---|
Et si on |
and issues on warning saying:
Level | Code | Message |
---|---|---|
Warning | 1366 | Incorrect string value: '\xE9tait ...' for column 'line' at row 1 |
Note: This can be corrected by specifying the default charset of the local FEDERATED table as DEFAULT CHARSET=UTF8 or by explicitely defining the local table column not specifying its character set. But this is not clearly documented.
Attachments
Issue Links
- relates to
-
MDEV-7343 corrupted text using connect
- Closed