mediumtext union all on mysql 5.7.11

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
andrea.m86
Posts: 25
Joined: Thu 26 May 2011 10:36

mediumtext union all on mysql 5.7.11

Post by andrea.m86 » 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)

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: mediumtext union all on mysql 5.7.11

Post by ViktorV » Tue 05 Jul 2016 14:20

Thank you for the information. We have reproduced the problem and investigation is in progress. We will inform you when we have any results.

Post Reply