Re: Reading text from a BLOB field
Posted by: Rick James
Date: July 25, 2012 12:02AM

"Reading text from a blob field" is not something that should ever be done.
MySQL will not alter the bits in that field in any way -- either on INSERT or SELECT. Something else is causing the question marks, etc.

We really need a lot more info about what is in the BLOB.
And how you are reading it.
And what other things in your 'client' may be fiddling with the encoding. (Java is likely to interject a conversion.)

Read this, and provide the debugging info it suggests:
http://mysql.rjweb.org/doc.php/charcoll

Options: ReplyQuote


Subject
Views
Written By
Posted
80280
July 20, 2012 10:21AM
Re: Reading text from a BLOB field
17293
July 25, 2012 12:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.