[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