How to store varbinary in MySQL?

mysql types varbinary
Nirmal picture Nirmal · Feb 2, 2010 · Viewed 8.2k times · Source

Just a quick question..

Out of two options mentioned below, how to store to varbinary column in MySQL?

public_key = '67498930589635764678356756719'

or

public_key = 67498930589635764678356756719

Will the second method work? I am into an emergency moment working on a production server and didn't want to experiment on it.

Thank you for any help.

Answer

Håvard S picture Håvard S · Feb 2, 2010

Printable data can be inserted using quotes. Non-printable data can be inserted using hexadecimal values. I.e.:

INSERT INTO Table(VarBinaryColumn) VALUES('Printable data') -- Will be stored as binary representation using the charset of the operating system

INSERT INTO Table(VarBinaryColumn) VALUES(0x12345) -- Non-printable binary data

Related questions

What is the size of column of int(11) in mysql in bytes?

What is the size of column of int(11) in mysql in bytes? And Maximum value that can be stored in this columns?

Read More
What data type to use for hashed password field and what length?

I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords to 4-20 characters, but as I understand after encrypting hash string will be of different length. …

Read More
Types in MySQL: BigInt(20) vs Int(20)

I was wondering what the difference between BigInt, MediumInt, and Int are... it would seem obvious that they would allow for larger numbers; however, I can make an Int(20) or a BigInt(20) and that would make seem that it is …

Read More