CODEWITHSUNDEEP
sqlsql-serversql-server-2008t-sql
Danny Beckett
Danny Beckett

Reputation: 20806

BZip decompress

Is there a way to decompress a BZip2 compressed string in MS SQL? Other than using xp_cmdshell and running it through bzip2.exe?

I have a string like BZh41AY&SY3‹Ï¬€ !˜„]ÉáB@Î/>° this is simply 'test'

Upvotes: 0

Views: 253

Answers (1)

Oded
Oded

Reputation: 499262

You could use SQL CLR to do this - utilizing the GZipStream class to decompress the value, or some third party library if you so choose.

Upvotes: 1

Related Questions