Questions tagged [hex]
The hex tag has no usage guidance.
4
questions
0
votes
2
answers
2k
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-...
- 435
0
votes
1
answer
380
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 ...
0
votes
2
answers
1k
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 ...
- 129
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 ...
- 522