mediumtext union all on mysql 5.7.11
Posted: Fri 01 Jul 2016 13:14
Hi,
We have this kind of issue:
We have a connection with the flag UseUnicode enabled and a datatype mapping where every Blob is mapped in a WideMemo.
Everything was working well untill we upgraded our database to MySQL 5.7.11 (and 5.7.13).
Now
A query component with a UNION ALL in the sql text on two MEDIUMTEXT field return a result with wrong characters
("perché fai così?" is showed as "perché fai così?")
The Mapping defined in the connection seems to fail.
If in the same component we change the query using UNION instead of UNION ALL the results are displayed well.
If we define a specific Datatype Mapping for the field (using the fieldname) converting it in a WideString the result is showed well again.
(We are using the latest version of the components)
We have this kind of issue:
We have a connection with the flag UseUnicode enabled and a datatype mapping where every Blob is mapped in a WideMemo.
Everything was working well untill we upgraded our database to MySQL 5.7.11 (and 5.7.13).
Now
A query component with a UNION ALL in the sql text on two MEDIUMTEXT field return a result with wrong characters
("perché fai così?" is showed as "perché fai così?")
The Mapping defined in the connection seems to fail.
If in the same component we change the query using UNION instead of UNION ALL the results are displayed well.
If we define a specific Datatype Mapping for the field (using the fieldname) converting it in a WideString the result is showed well again.
(We are using the latest version of the components)