Issue Bug Closed

#16299BLOBs doesn't work in Oracle (in the WHERE clause)

Martin Kutschker 06/27/06, 19:37 updated 06/27/08, 10:52

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.