Read Data from MySQL Server in HEX

Projects Programming
1

Hello,

I am able to send data from Arduino to a Server using GSM SIM800L. The data is being sent in HEX format. Though, as per my understanding, there is no provision to store HEX data in MySQL, the data gets converted to the corresponding INT values (as I have given the datatype as INT in the table of my database) and is stored.

Now, I need to fetch this data and send it to a different module. How I can convert this data back to HEX while retrieving it?

Thanks in advance.

Regards,
Anuvandan Dave

2

How I can convert this data back to HEX while retrieving it?

Write some code.

If you need help, show us the code you have that sends data "in HEX format" so we can see what you are talking about.

3

Hello Paul,

Thanks a lot for the reply. I will post this scenario in coming days. I am stuck in a different problem now (posted in forum) and solving that problem should lead me to the above mentioned situation.