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] 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. 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 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
Archived
This topic is now archived and is closed to further replies.