Blob - 255b

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

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?

Quote:

---

Originally Posted by 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?

---

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

Code:

---

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

---

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

Hmm, then my navicat is stupid >.<

Quote:

---

Originally Posted by renan7899

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)

any jsp query to decode it?

Quote:

---

Originally Posted by Adriana

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