upload binary data to MSSQL

[enterume]

Hi,

I try to uplaod a binary data to MSSQL, but it always return me the error.

DB Error: : INSERT INTO repo (id,text,img,fsize) VALUES ('100','wwww',"0xGIF89aXÕÿÀÀÀÿÿÌÿÌÿÿÌÌÿÌ™ÿÌfÿÌ3ÿ™™ÿ™3ÿ™ÌÿÌÌÌÿÌÌÌÌ™ÌÌfÌÌffÌ3ÌÌ33Ì™Ìf™™Ì{t^fø;všÍÕÄy=³ßE‰;",'582')

I read some doc it say need to SET TEXTSIZE, but fail to run the query.

Thanks
Louis

[bastien]

it had better be BLOB or it will fail

[enterume]

Hi,

Can you show a simple sql statement for this? I am newbie for MSSQL command.

THanks
Louis

[bastien]

the field type should be set to BLOB (Binary Large OBject)?

what is the data like that you are storing (file?image?)?

[enterume]

I try to store Image and file as well.

IS there a BLOB in MSSQL datatype? I use Image instead.

One question, do i need to convert to hexdecimal when insert to MSSQL ?