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

I have an encrypted files in the table DOCUMENTDATA:

Example of the data:



SQL Fiddle

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

How can I decode it?


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


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