Convert VarBinary RTF blob to text in MS SQL

Question

I am using SQL Server - 2008.

Column Datatype - VarBinary

The RTF file is compressed and stored in this varbinary column.

Now how to access and view data in RTF file using SQL?

it returns this: 㠰た㠴弰巎楛㵤㠵㜸ㄲ㠴.

etc.

An example of tried code here:

http://rextester.com/YOFHK34016

any solution to this. in 2008 the decompression and compression function does not work. how can i get RTF file like text.

+2

rohit patil 08 Aug 17 at 11:51

2 answers

Gleb · Answer 1 · 2017-08-09T05:25:54+0000

This works for me:

select convert(varchar(max),convert(varbinary(max),bv.value)) from blobValue bv

Try using varchar instead of using nvarchar. But I said it would return rtf-formatted text, something like:

"{\rtf1\ansi\ansicpg1251\deff0\deflang1049{\fonttbl{\f0\fnil MS Sans Serif;}{\f1\fswiss\fcharset0 Arial;}"

To get real text, you can use .Net dll to convert it. You can add .net dll to your database instead of calling it functions from Sql script. More on this: Call dll function from sql stored procedure using current connection

nenea · Answer 2 · 2018-05-04T15:47:30+0000

This worked for me, thanks to a bunch. I used:

SELECT convert(nvarchar(max),convert(varbinary(max),[FORMULATEXT]))