TYPO3 Mailingliste: nicht fragen - lesen!

Hi All,

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.

Thanks in advance.

Unai Aizpurua
unai (AT) alambre (DOT) net
_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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 (DOT) 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
>
_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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




_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products