How to store varbinary in MySQL?

Question

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.

Håvard S · Accepted Answer · 2010-02-02 09:19:12Z

10

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

answered Feb 2, 2010 at 9:19

Håvard S

24k9 gold badges64 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store varbinary in MySQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related