[TYPO3-dev] MySQL, search and utf8

[Elmar Hinz]

Steffen Kamper wrote:

> 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


Hi Steffen,

apropos characterset. Your news client let's readers guess what it may be. I
needed to select it manually to see the Ös. Hope my client makes it
better. :->

You know this page? (Could need some tidying).

http://wiki.typo3.org/index.php/UTF-8_support

Have a look at the:

 TYPO3 Install Tool Options

Regards

Elmar