Member Avatar for kv79

Hallo there,

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

Thanks,

Danijel

Edited by pritaeas because: Moved.
  • 3 Contributors
  • 3 Replies
  • 339 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for AndreRet

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.

Member Avatar for kv79

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

Thanks for letting me know.

Member Avatar for pritaeas

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.