[TYPO3-shop] Uppercase and and lowercase

[Franz Holzinger]

Hello Unai,

> 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.

Try such a query in phpMyAdmin:

SELECT *
FROM `tt_products`
WHERE title LIKE '%blue'


This will find as result:

Brilliant Blue
Skyhigh Blue

So this is not case sensitive.

SELECT *
FROM `tt_products`
WHERE title LIKE '%BLU%'

Gives me the same result.
Maybe you MySQL is misconfigured.

- Franz