As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [hex]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
351 views

Convert hex string representation to hex number in SQL Server T-SQL

I have been given a dataset where hexadecimal numbers have been stored as a quasi-hex string representation intended to be human-friendly, e.g. "16A1". Is there a conversion function in T-...
Tim's user avatar
  • 435
0 votes
1 answer
199 views

Covert from literal HEX value to INT MariaDB

I have a situation where i need to get the integer value from a literal hex. Example: "ff" equals 255 in decimal, but if i use the HEX("ff") function it returns 6666. Is it ...
Adelina Andreea trandafir's user avatar
0 votes
2 answers
830 views

Error on updating a field with binary values

I have a problem on emoji showing on webpage after migration to new DB Server. But I have a workaround. I will get the binary values of a certain field of TABLE1 on our OLD DB Server. Then update the ...
JRA's user avatar
  • 109
0 votes
2 answers
1k views

64 bit hexadecimal AS Date in SQL

I am loading a Qlikview CalData PGO XML file into a SQL table. Dates in this XML are stored as a 64 bit HEX string and I need to convert it to a date. How do I do that? Example 40e58f2c4153d0f9 should ...
mouliin's user avatar
  • 522