Incorrect date display

when I run the following SQL:

select left(table1.modified,10) from table1
left join table2 on table1.id=table2.id
inner join table3 on table1.id=table3.id
order by 1;


so that the dates appear in the grid:
0x323031302D31302D3138

if I delete one of the "join"
then the grid displays a good date!

I think the problem is the processing of SQL...

Try a recent version of HeidiSQL.

If I recall correctly, that's a bug in some versions of MySQL server (that incorrectly tag the result as binary) and HeidiSQL implemented a workaround.

Exactly, older servers return a binary collation for computed columns in various cases. But even in these cases you can press the white button on the main toolbar, with the red "0x" on it: "View binary data as text"