varbinary column values can't be showed correctly, show in Ox format
| User, date | Message |
|---|---|
|
Written by popgo
3 years ago Category: General 5 posts since Thu, 01 Jul 10 |
varbinary column values can't be showed correctly, show in Ox format |
|
Written by popgo
3 years ago 5 posts since Thu, 01 Jul 10 |
varbinary column values are showed in hexadecimal format "message_id","HEX(bounce)","begin_time","total_count","send_count","sbb_count","hbb_count" "323","6D73675F3332335F73756273637269626572","2010-05-26 09:15:00","16","16","0","0" "324","6D73675F3332345F73756273637269626572","2010-05-26 10:43:36","10016","8372","55","261" "325","6D73675F3332355F73756273637269626572","2010-05-26 10:44:07","20016","4765","31","11" "326","6D73675F3332365F73756273637269626572","2010-05-26 10:44:39","10016","4751","23","33" "327","6D73675F3332375F73756273637269626572","2010-05-26 10:45:15","20016","4728","22","57" |
|
Written by ansgar
3 years ago 3950 posts since Fri, 07 Apr 06 |
Well, hex is not incorrect, is it? However, you can force to show it as text, when you click the "View binary data as text" button on the main toolbar - the white "page" icon with the "0x" on it. |
|
Written by popgo
3 years ago 5 posts since Thu, 01 Jul 10 |
thanks |
|
Please login to leave a reply, or register at first. |