make sure in your datasource, in the advanced settings, that you've checked enable binary large object retrieval
On 3/1/06, Michael Traher <[EMAIL PROTECTED]> wrote: > 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:233726 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
