how to convert blob into string

[kamill]

Hi all
I have stored password in blob format, now i need to fetch data from table in readable text format. How can i do this.

Regards
Kamill

[Atli]

Hi Kamill.

Why would you store text in a BLOB field?

How exactly was the text inserted into the BLOB field?
What type of charset did the text use before it was inserted?