[TYPO3-shop] Uppercase and and lowercase

[Franz Holzinger]

Hello

> When I make a search in tt_products and it searchs exactly in capital
> letters and small letters.
> 
> Perhaps the person who makes the search types all in capitals and the
> results shows nothing when the product exists.
> 
> There is a property for search exact matches in capitals and small
> letters? I haven't seen it.

tt_products uses the TYPO3 method tslib_cObj::searchWhere. This does not
support case sensitive searches.

It will give back SQL where clauses like

WHERE name LIKE '%Abc%'

This will be case insensitive in MySQL.

What you need ist

WHERE name LIKE BINARY '%Abc%'

So you can make a feature request on the bugtracker for TYPO3 Core to
extend the API to make it case sensitive.

function searchWhere($sw,$searchFieldList,$searchTable='')	{

- Franz