Hallo there,

does someone knows, where is the use of VARBINARY in MySQL database?

Thanks,

Danijel

You will find everything about binary and varbinary here.

The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they contain binary strings rather than nonbinary strings. That is, they contain byte strings rather than character strings. This means that they have no character set, and sorting and comparison are based on the numeric values of the bytes in the values.

The permissible maximum length is the same for BINARY and VARBINARY as it is for CHAR and VARCHAR, except that the length for BINARY and VARBINARY is a length in bytes rather than in characters.

I understood your anwer that these things are still theroy that didn't found use in the real world. :)

Thanks for letting me know.

didn't found use

Of course it has a use. It's an excellent column type to store encrypted data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.