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

[expired user #5024]'s profile image [expired user #5024] posted 14 years ago in General Permalink
varbinary column values can't be showed correctly, show in Ox format
[expired user #5024]'s profile image [expired user #5024] posted 14 years ago Permalink
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's profile image ansgar posted 14 years ago Permalink
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.
[expired user #5024]'s profile image [expired user #5024] posted 14 years ago Permalink
thanks

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