Actions
Bug #16299
closed
BLOBs doesn't work in Oracle (in the WHERE clause)
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-06-27
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
In Oracle you cannot simply fetch data via SELECT from a BLOB field. Neither in when specified in the SELECT clause directly by name nor indirectly by *.
This fails:
SELECT "blob" FROM "blobtable"
SELECT * FROM "blobtable"
To overcome this problem DBAL could use CBLOB or long VARCHARS 2(4000) [yes, they me be up to 4000 chars!) instead. As TYPO3 usually stores only strings and not real binary data both variants are an option.
Alternatively TYPO3 could switch to type TEXT. So TEXT can be mapped to CBLOB.
(issue imported from #M3762)
Updated by 
Updated by
Actions