We receive html files and store them as blob in an Oracle database as datatype BLOB and document_type text/html. We then extract that blob using a PHP application in Firefox or IE. All this worked fine until recently when the blobs suddenly opened in Firefox as text file showing all the html code. In IE there is no problem. When i looked at the html file i noticed a line in the html files that has no problem and that reads as
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
If i compare that with the file that has the problem, the corresponding statement is replaced with
<meta http-equiv=Content-Type content="text/html; charset=unicode">
And indeed, when i replave unicode everything is ok.
Now, opening both html files directly from my PC is ok in Firefox and IE.
Because the html files are coming from an external organisation i don't have direct control on the content.
My questions :
what confuses Firefox when the html file is stored as blob ?
can i tell Firefox to open the file as html ?
can i solve this by modifying the way in which the file is uploaded as blob ?