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

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

popgo posted 4 years ago in General
varbinary column values can't be showed correctly, show in Ox format
popgo posted 4 years ago
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"
ansgar posted 4 years ago
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.
popgo posted 4 years ago
thanks

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