[TYPO3-dev] MySQL First Letter and Umlauts

[Steffen Kamper]

>I think, there is no solution :(

>I spent days with research about this problem.
>I asked this list, but no satisfying answers ...

>The problem is, that Mysql is missing a function like
>     CONVERT_TO_KOLLATION_EQUIVILANT(text)
>that converts e.g. a to ae, o to oe etc.

>The only way is to use a huge REPLACE()-Construct :(

>Stefan
Hi Stefan,

hmm - that's indeed no good news. So the only way atm is to do this in php 
as reading results to an array and manipulate the array before compute, not 
really satisfying.

vg  Steffen