guvna Posted December 22, 2017 Share Posted December 22, 2017 Scripts 1, 2 and 3 from page 238 all work fine. When I run script 4 on page 239 and run: SELECT 8 FROM customers WHERE customer_id=1; the table displays 'BLOB' in the pin field rather than the expected '1234'. I did look up BLOB erros and my character set is definately utf8 with collation utf8 general ci. Link to comment Share on other sites More sharing options...
guvna Posted December 22, 2017 Author Share Posted December 22, 2017 It was SELECT * that was run, keyboard was in another language setting. Link to comment Share on other sites More sharing options...
guvna Posted December 22, 2017 Author Share Posted December 22, 2017 it might be a MySQL Workbench thing as I can right click the BLOB icon then left click 'open in viewer' then see the result '1234' in the text tab. Link to comment Share on other sites More sharing options...
Larry Posted December 27, 2017 Share Posted December 27, 2017 I don't regularly use MySQL workbench for queries so I'm not positive what's going on but it sounds like you've hit upon the issue. Link to comment Share on other sites More sharing options...
Recommended Posts