Thanks for the answer but I am using ColdFusion now with an ODBC connection :-(
I now know where my problem was: the inserted file is truncated when a NULL character is found in the file. I will try to Base64 it before storing it into the DB. Is there a function to do it with SQL Server?
Hi everyone,
Does anyone know how to store files directly in a database?
I need to develop an upload feature on a Website and I would like to store the uploaded files in SQL Server. I tried to use the text data type for this and insert the file in it:
insert into Files (fileName, mimeType...
Hi everyone,
I have a generic database and I want to add new tables which are specific to a project I am working on.
For this, I thought of creating a new database containing the new specific tables (which have relationships with other tables in the generic database). I therefore need to link...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.