Man, the more I see and experience things like this in MySQL, the more impressed...

ars · on Aug 1, 2012

This isn't really a MySQL issue though. He used bin instead of int, and MySQL did exactly what he asked - stored the raw binary data as is.

drivebyacct2 · on Aug 1, 2012

Why are rows with 'y' in them being returned when he asked for that value equal to zero?

ars · on Aug 1, 2012

No idea. I would expect it to convert the 0 to a binary format (since that's the format of the column) but it's not.

It does raise warning

   1292: Truncated incorrect DOUBLE value: 'y  '
   1292: Truncated incorrect DOUBLE value: 'y  '

(Yes, twice.)

Which makes no sense to me.