Devart Forums

select ..., concat('CHA-', charges.chargeid), ....

Navicat correctly returns CHA-15 while MyDAC returns CHA only.

5.10.0.10 Delphi 7
and chargeid = unsigned smallint

edit
----

I just noticed that it happens only with Options.UseUnicode = true

I cannot reproduce the problem, please provide me with some additional information:
- a script to create a test database with a test table;
- a script to insert a couple of records in the test table;
- results of the following queries performed from your application:
SHOW VARIABLES LIKE '%collation%';
SHOW VARIABLES LIKE '%character_set%';
- the exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.