[TYPO3-dev] MySQL, search and utf8

Steffen Kamper steffen at sk-typo3.de
Mon Oct 8 20:02:13 CEST 2007


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 






More information about the TYPO3-dev mailing list