[TYPO3-dev] MySQL, search and utf8

[Steffen Kamper]

"Steffen Kamper" <steffen at sk-typo3.de> schrieb im Newsbeitrag 
news:mailman.1.1191866513.10281.typo3-dev at lists.netfielders.de...
> Hi,
>
> i have a non-TYPO3-question.
>
> I perform a search in MySQL and for example look for the word "schön". So 
> my query looks like:
>
> Select .... where ... and (body like "schön%" or body like "%schön%" or 
> body like "%schön" or body = "schön")
>
> looking to the results i see that MySQL shows up result with the word 
> "schon" which is different. Thoug it is utf8, the letter ö is saved in 
> utf8 as 2-Byte, so why gives MySQL me the result with o?
>
> And how can i provide this to get only exact matches with "schön"?
>
> thx, vg  Steffen
>

it seems that like is not binary safe in utf8-context.

I got the right results by using LIKE BINARY, so my query works like this:

SELECT * , count( * ) anz
FROM tx_drwiki_pages
WHERE hidden =0
AND deleted =0
AND (
body LIKE binary "schön%"
OR body LIKE binary "%schön%"
OR body LIKE binary "%schön"
OR body = "schön"
)
GROUP BY keyword
ORDER BY anz DESC

vg  Steffen