dsdsdsdsd Posted August 9, 2010 Share Posted August 9, 2010 hello; spontaneously one of my tables is showing "[bLOB - # Bytes]" in every field; all columns are set to TEXT, and the table and all columns are set to utf8_bin; the data is read from the table correctly, however. any thoughts; thanks, Shannon [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/210212-all-fields-showing-blob-bytes/ Share on other sites More sharing options...
fenway Posted August 10, 2010 Share Posted August 10, 2010 utf8_bin = binary, not text. That's all. Quote Link to comment https://forums.phpfreaks.com/topic/210212-all-fields-showing-blob-bytes/#findComment-1097305 Share on other sites More sharing options...
dsdsdsdsd Posted August 10, 2010 Author Share Posted August 10, 2010 aha ... setting it to utf8_general_ci did the trick; thanks for your time. Shannon Quote Link to comment https://forums.phpfreaks.com/topic/210212-all-fields-showing-blob-bytes/#findComment-1097407 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.