Convert rtf blob to text in MS Sql

Question

I working with database. In this database I have a table with blob field. This field contains rtf text. If I'am doing like this:

select convert(nvarchar(max),convert(varbinary(max),blob_column)) from table_with_blob

it's returns this: せ〰〰〴ㄷⴶ㠰た㠴弰巎楛㵤㠵㜸㔰⁝ﳲ茶￠∠ⰳㄲ㠴.

So my question is how to convert this rtf blob to text using MS Sql 2008?

Answer 1

try with this, it should work

select convert(varchar(max),convert(varbinary(max),blob_column)) from table_with_blob

take the reference from below script -

DECLARE @blob VarBinary(MAX) = CONVERT(VarBinary(MAX), 'test');
-- show the binary representation
SELECT @blob;
-- this doesn't work
SELECT CONVERT(NVarChar(100), @blob);
-- but this does
SELECT CONVERT(VarChar(100), @blob);