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

varbinary column values can't be showed correctly, show in Ox format

User, date Message
Written by popgo
4 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
4 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
4 years ago
5023 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
4 years ago
5 posts since Thu, 01 Jul 10
thanks
 

Please login to leave a reply, or register at first.