U
U
Urukhayy2015-08-19 11:49:47
MySQL
Urukhayy, 2015-08-19 11:49:47

How to organize storage-use of HEX number in mysql?

Initially, a HEX number (By type - 0xFFFF00FF) is assigned to a certain integer variable.
You need to store it in the mysql database and then assign it to this integer variable again. How to do it?
Or is it easier to convert to decimal? Whereas?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexey Ukolov, 2015-08-19
@Urukhayy

HEX()
UNHEX()

V
Vladimir Martyanov, 2015-08-19
@vilgeforce

Store as decimal in mysql and as unsigned long in the program, then there will be no problems in conversions.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question