How can I decode data (probably ZLIB) using SQL Server?

I have an encrypted files in the table DOCUMENTDATA:

Example of the data:

0x78DA2B2E492C2A0100068F022F

0x78DA333232335200034597D49CCCB2D4A2CAF89AB89AD0829CFCC494D4947838000A3AE7E7A56516E5A28986181A2914A526A702F5C22478B90008741E52

SQL Fiddle

It looks like ZLIB format because of the first bytes 0x78DA.

How can I decode it?

Answers


Indeed, they are zlib strings. The first example is the string start. The second is 2262 !Delivery_|^|Uploaded__________|^|Confirmed__________|^|T12 received_______. They are not encrypted.

How to decompress depends on how you are accessing the SQL server. What language are you using? On what platform?


Need Your Help

hiding address bar and status bar in IE8

javascript

How can I hide the status bar and address bar through JavaScript? I have the following code: