4 ms·
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.
by ars 14y ago
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 14y agoWhy are rows with 'y' in them being returned when he asked for that value equal to zero?
- ars 14y agoNo 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.