I'm trying to allow files to be uploaded and stored in our database. so far this seems to work best by converting the file with tobase64(file_contents) and then writing the resultant string to a long varchar column.
my issue is that it only works for smallish files around 5-6K. I have not found the exact boundary on size but 29k word doc failed with 'string too long' I'm not sure at this stage which layer is complaining? CF JDBC driver JDBC server DBMS a long varchar on our database can hold upto 2GB so that is not the limit. Anyone done this? Or have any pointers? -- Mike T Blog http://www.socialpoints.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
