Some rows in my database are shown in binary format. DateTime values are shown as below in Sqlyog.
DC1203-68-58 51:18:72 Æ420-94-57 38:13:76 \722-49-30 63:17:35 ETB801-61-42 37:69:60
When i retrieved these from UI, displayed correctly as 2014-08-19 21:44:17.0 2014-08-19 21:44:17.0
and also some varchar columns are displayed as (Binary/Image). when i Export to Excel i found the values like \0\0\0\0\0í\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\01\0
But in UI displayed normally as 'OID-231-9k48wknuyc9376rj'
Can any one please please tell me what i need to do to make these values to display in normal format? what made these values to display like this? Mysql Version--------> 5.5.16-log SqlYog --------->1.0.0.1
Thanks in Advance.
Aucun commentaire:
Enregistrer un commentaire