Converting from hex string to varbinary and vice versa

a-foton » Converting from hex string to varbinary and vice versa

a-foton » Converting from hex string to varbinary and vice versa — Thu, 03 Jul 2008 04:39:18 GMT

PingBack from http://blog.a-foton.ru/2008/07/converting-from-hex-string-to-varbinary-and-vice-versa/

Problem with data being converted to ASCII character representations

SamCPP — Mon, 17 Nov 2008 04:27:07 GMT

Hi,

I am running SQL Server 2008 Enterprise Evaluation with Cumulative Update 1 installed. When I process your sample in Query Analyzer, my results for the select queries are:

0x3078616263656466303132343339

and

0x616263656466303132343339

so it has converted the characters to the binary representation of the ASCII rather than what I expected:

0xABCEDF012439

Is there a flaw with CONVERT now? Or is that expected behaviour?

re: Converting from hex string to varbinary and vice versa

SamCPP — Mon, 17 Nov 2008 06:17:47 GMT

Sorry I was connected from a SSMS 2k8 to a SQL Server 2005 server.