how can store hexadecimal value inside mysql database?

Question

1) how can store hexadecimal value inside MySQL database?
==> i want to store SQL data to MySQL.
==> in SQL data store inside image datatype that i want to store in MySQL
database. how?

http://stackoverflow.com/questions/3126210/insert-hex-values-into-mysql — Renjith V R, Feb 27 '16 at 09:19
http://stackoverflow.com/questions/1712934/storing-hexadecimal-values-as-binary-in-mysql — Renjith V R, Feb 27 '16 at 09:19

score 0 · Answer 1 · answered Feb 27 '16 at 09:19

0

You can use UNHEX() for inserting and HEX() for selecting that HEXADECIMAL

INSERT INTO table (column) VALUES (UNHEX('ABCD1F'))

or

SELECT HEX(column) FROM table

answered Feb 27 '16 at 09:19

Gopalakrishnan

957
8
19

score 0 · Answer 2 · answered Feb 27 '16 at 09:20

0

You can use UNHEX() function to convert a hexstring with hex pairs to binary and HEX() to do the other way round.

I.e.

INSERT INTO tbl (col) VALUES (UNHEX('4D2AFF'))

and

SELECT HEX(col) FROM tbl

answered Feb 27 '16 at 09:20

Drudge Rajen

7,584
4
23
43

how can store hexadecimal value inside mysql database?

2 Answers2