[TYPO3-core] RFC #15001: Bugfix: It is not possible to search for '%' or '_' inside the Backend

[Xavier Perseguers]

Hi,

> +1 by reading and testing for non-DBAL
>
> However the patch for DBAL still is not valid, at least for Oracle (I'm
> always testing it first there and then in other DBMS). Problem is that
> Oracle needs a special way of searching for wildcard characters. What is
> done with the patch is that for any page whose title contains '%':
>
> SELECT * FROM pages WHERE title LIKE '%\%%'
>
> However with Oracle this does not work, one has to write (quotes added
> to be Oracle compatible):
>
> SELECT * FROM "pages" WHERE "title" LIKE '%\%%' ESCAPE '\'
>
> and this is currently not supported by DBAL. However this works:

Actually this is exactly the same with MSSQL.

Xavier