I'm using ColdFusion 2018, Oracle 12c, and IIS 10. I setup a page to upload Microsoft Word files with a DOCX file extension into a BLOB field into the database. When I use the website to open the file all I see is the text. The problem is I do not see any images that were pasted into the file before it was uploaded.
In IIS there is a MIME Type of DOCX.
The upload query is similar to:
<cfquery datasource="my_dsn">
INSERT INTO my_db_table (
File_Name,
File_Content
)
VALUES (
<CfQueryParam CfSqlType="cf_sql_varchar" value="#File_Name_Value#">,
<CfQueryParam CfSqlType="cf_sql_blob" value="#File_Content_Value#">,
)
</cfquery>
The query to get the file from the database is similar to:
<cfquery datasource="my_dsn" name="my_query">
SELECT File_Name, File_Content
FROM my_db_table
WHERE File_Id = "#File_Id_Value#"
</cfquery>
AdChoices