Re: Reading text from a BLOB field
"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
Subject
Views
Written By
Posted
78446
July 20, 2012 10:21AM
Re: Reading text from a BLOB field
16953
July 25, 2012 12:02AM
11199
July 31, 2012 02:35PM
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.