Blob - 255b

[Adriana]

Anyone know how to decode BLOB - 255B???

[MentaL]

[renan7899]

blob can't be decoded... It's simply "blob", nothing else. :x

I'll try to change it to varchar and see if the ban reason appear... Hmm, well, you're talking about forbid table, right?

[das7002]

blob can't be decoded... It's simply "blob", nothing else. :x

I'll try to change it to varchar and see if the ban reason appear... Hmm, well, you're talking about forbid table, right?

Yes it can... a blob is a Binary Large OBject which means you can read it as hex to edit if you wish...

hex(select `blobcolumn` from `tablename` where `something` = 'something')

remember backticks ` are for column or table names and apostrophes ' are for strings!

[renan7899]

Hmm, then my navicat is stupid >.<

[das7002]

Hmm, then my navicat is stupid >.<

I'm pretty sure you do have it... After double clicking the table name you should get the rows etc and then there is a button near the top for hex http://dl.dropbox.com/u/1178264/scre...avicatblog.png (I assure you that is a blob column not a string one even though both would look the same)

[Adriana]

any jsp query to decode it?

[das7002]

any jsp query to decode it?

Use the MySQL JDBC to use it... pwAdmin has a few examples somewhere in it and a quick google provides many more