Welcome Guest, Not a member yet? Register   Sign In
Insert binary value into table fails.

(This post was last modified: 11-19-2018, 02:18 AM by neuron.)

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 Smile.

Messages In This Thread
RE: Insert binary value into table fails. - by neuron - 11-19-2018, 02:18 AM

Theme © iAndrew 2016 - Forum software by © MyBB