Incorrect date display
| User, date | Message |
|---|---|
|
Written by sod
2 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
2 years ago 442 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
2 years ago 3975 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. |