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.