[TYPO3-dev] MySQL First Letter and Umlauts

Steffen Kamper steffen at sk-typo3.de
Fri Oct 26 12:20:44 CEST 2007


"Malte Jansen" <mail at maltejansen.de> schrieb im Newsbeitrag 
news:mailman.1.1193393050.27499.typo3-dev at lists.netfielders.de...
> Hi!
>
> I don't if there is Something, you could change the charset in mysql to an 
> other utf-charset. A while a go I sortet something with latin_german1 and 
> latin_german2. Perhaps there is some equal with utf8. I know there 
> language-charset. But I don't if there is something for german... So you 
> could change the column to this charset.
>
>
> Malte
>

Hi Malte,

yes, i could use another collation for this query, that would solve one 
problem. (unfortunally the MySQL on this server has no german charset)
The other still exists - as i need the distinct first letter to build the 
A-B-C-... the Ä (Auml;) gives me a *new* char but i don't want, i want it in 
section A

but i see - if i make condition for letter<127 in my loop may be this could 
be solved.

vg  Steffen 






More information about the TYPO3-dev mailing list