[TYPO3-shop] Uppercase and and lowercase

[Unai Aizpurua]

Hi Franz,

Perhaps my poor english is not helping me.

I have this products:

1001 ACAENA VERDE
1002 AGAVE PLANT
2121 AGAVE MARRON

When I search: "agave" nothing is found.

When I search "AGAVE" there are two results found.

What I want is that are two results in the two cases not only in Case 
Sensitive.

Thanks a lot four you helping and the excelent extension!!

Unai Aizpurua
unai at alambre.net


Franz Holzinger escribió:
> 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
>