Questions tagged [hex]
The hex tag has no usage guidance.
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-...
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 ...
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 ...
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 ...