Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Get the file content which is stored as Varbinary(

Author  Topic 

fresher1234
Starting Member

6 Posts

Posted - 2010-11-02 : 13:44:10
hi,
I have a table which has column filecontent as varbinary(max).
To look at file contents i gave
select filecontent convert(varchar(max),filecontent) from dbo.Attactment;
It is returning RH32!oP under filecontent column.

How to see the file contents.

I need to take the file contents as String in my Java program.
Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2010-11-02 : 13:55:34
well...what's stored in there?

PDF's?

Another reason not to store doc's in a database

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx





Go to Top of Page

fresher1234
Starting Member

6 Posts

Posted - 2010-11-02 : 14:33:04
I am storing both pdf and text files.
Go to Top of Page
   

- Advertisement -