Store Big Rtf

[vtops]

Dear All,

I have an application which it exports many kinds of rtf formats (images,excel sheets,word documents etc).

My Problem is that i don't know how can i save it on a table of sql database.

I tried with Image and varbinary type, but i have always the error message:

Operand type clash: text is incompatible with image
Operand type clash: text is incompatible with varbinary


I tried also with Text Type, but the rtf did'nt saved complete.


the syntax of the command i used is like this:

insert into mytable(mycolumn) values ('The RTF')

The length of the rtf is over than 300000 characters.


Please Could you help me with that ?


Thank in advance

 

[sodakotahusker]

Did you try without the quote marks?

 

[jbenson001]

For data that size you need to use a Text column.

check these functions in Books On Line

WRITETEXT

UPDATETEXT