Lab Sql

I have a database in TSQL that contains columns in hexadecimal. However these values are padded wit… Read more Removing Padded Zeroes In Hexadecimal Column

What is a construct in SQL Server T-SQL that will replace a Char(0), the null character, embedded i… Read more In Sql Server, Replace A Char(0), The Null Character, Embedded In A String With Its Hex Code

Amazon Redshift is based on ParAccel which is based on Postgres. From my research it seems that the… Read more Hex String To Integer Conversion In Amazon Redshift

Is there any way to obtain an hexadecimal dump of a string in SQL Server? It'd be useful to tro… Read more Show Hexadecimal Dump Of String

I'm trying to convert hex string (starts with '0x') to it's integer value using pre… Read more Presto - Hex String To Int

I am trying to find a way of converting HEX to a float in SQL Server. An example value is 0x42c8000… Read more Converting Hex To Float Sql

This is a follow on from: Python - Converting Hex to INT/CHAR I now have a working solution for con… Read more Python - Reading Blob Type From Sqlite3 Db