jeudi 5 février 2015

Ascii Symbols are Shown In varchar and Datetime Column Values of Mysql


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