Incorrect date display

User, date Message
Written by sod
4 years ago
Category: Running SQL scripts
1 posts since Fri, 18 Feb 11
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:

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

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

Written by kalvaro
4 years ago
595 posts since Thu, 29 Nov 07
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.
Written by ansgar
4 years ago
5023 posts since Fri, 07 Apr 06
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"

Please login to leave a reply, or register at first.