[TYPO3-dev] MySQL, search and utf8

[ries van Twisk]

On Oct 8, 2007, at 7:16 PM, Elmar Hinz wrote:

> 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
>
>


Hey Elmar,

FYI, it has nothing to do with Character encoding, but using the  
right collation.

Ries