distal-attribute
distal-attribute
distal-attribute
distal-attribute

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:
0x323031302D31302D3138

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
594 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
4988 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.