read BLOB from sql query (solved)

txeriff

Hi all,

Hope some1 can help. Im trying to read a BLOB from sql but I dont get proper information. tried the following:

,convert(varchar(max),convert(varbinary(max),[campoBLOB]))COLLATE SQL_Latin1_General_CP1_CI_AI as campoblobbbbb
,convert(nvarchar(max),convert(varbinary(max),campoBLOB)) COLLATE SQL_Latin1_General_CP1_CI_AI as campoblobbbbb2

also without collation but data is wrong.

Any ideas?


Edit:

Found that uncompressed BLOB works fine but the accents. How could I fix them? As you can see in the image, red blox is standard NAV description text field. green is my BLOB field. it should show "saltó" in both cases. Any ideas?
thanks.

Edit2:

I managed to solve it using ansii2ascii codeunit I had. So I write values in ansi and read them writing back to ascii. It worked for me.

mik

Hi, here is a Version with an uncompressed blob. He is integrating a .net assembly.

https://devch.wordpress.com/2012/01/12/read-content-of-nav-notesblobs-from-sql/

with this you can also try his blob reading example from compressed blobs.

https://devch.wordpress.com/2014/01/21/accessing-compressed-blobs-from-outside-nav-nav2013-revisited/

Hope this helps ...

txeriff

mik wrote: »

Hi, here is a Version with an uncompressed blob. He is integrating a .net assembly.

https://devch.wordpress.com/2012/01/12/read-content-of-nav-notesblobs-from-sql/

with this you can also try his blob reading example from compressed blobs.

https://devch.wordpress.com/2014/01/21/accessing-compressed-blobs-from-outside-nav-nav2013-revisited/

Hope this helps ...

Hi,

i didnt want to go into deep`developemnt. Cant it be fixed the collation? as you can see Im very near to solution.