Insert binary value into table fails.

I don't have much experince in using binary type data in DB. 
Once, I tried to keep IP addresses in binary format in DB, it caused me a lot of headache.
I worked on  MySql v5.3, as I remember it does not have auto conversion method to convert string to Binary, I converted string to binary in PHP  and stored them in DB.
This conversion caused some problem when insertion/update because of special characters that generated when converting to binary.
and then it also was to problem when comparing (searching  an IP) it with some value.

From that time I avoid using binary types in DB.

So I suggest you to avoid binary types .