We are wanting to store PDF files in our Sybase 10 database. Some of them are up to 50 megabytes in size. I looked it up online and saw that the Image datatype in a table appears to hold what we need.
How do you implement this feature? I am new to using BLOB's in databases and am unsure how to encode the pdf data into binary and store it in the database.
IMHO I'm not a fan of using large blob files in server tables. You could think about a Directory Server where you can save you files in a directory of the server.
IF you use ASA 11 and above .....
To Transfer Files to the Server without additional Data Connections check out the Documentation about Access to data on client computers.
If you use ODBC to connect to the Server you can use it directly out of the box. Make sure that you statement includes the READ_CLIENT_FILE() function directly.
select READ_CLIENT_FILE('C:\\TEST.PDF') into BlobVar from dummy;
This will case an error !
select UDF_THAT_INCLUDES_A_READ_CLIENT_FILE_CALL('C:\\TEST.PDF') into BlobVar from dummy;
The ODBC Driver will do some magic on the executed Statement to get your data to the DB Server.