[TYPO3-dev] MySQL First Letter and Umlauts
Steffen Kamper
steffen at sk-typo3.de
Fri Oct 26 12:00:09 CEST 2007
> I don't have a suggestion, but please check the setup of your newsgroup
> client. The umlauts in your message did not show up correctly. The message
> itself is encoded in ISO-8859-1 while the mail-header seems to say nothing
> and thus it was shown in utf-8 in my case. So all your special chars
> (umlauts) where '?' before I switched to iso encoding. It's hard to
> understand your mails while only seeing question marks in the critical
> parts of your message ;)
>
> --
> Greetings,
> Franz
sry for that, i try same message with utf8 (unfortunally OE does not give me
a default setup for charset, i know - M$, but it's easy...):
i need a tip for an alphabetic List in mySQL (all in utf8).
I did this (for drwiki)
SELECT DISTINCT keyword,ASCII(UPPER(SUBSTRING(keyword,1,1))) letter FROM
`tx_drwiki_pages` ORDER BY letter
This works fine until the keyword starts with Umlaut, e.g. ÄÖÜ
The strange is that Ä results in ASCII 195, but it is 196 ...
Now i thout to use replace for that chars like REPLACE(keyword,'Ä', 'Ae'),
but i need more than one replace, i don't know how to do that in one query.
If i change ORDER BY to keyword i get the wrong order (well known in utf8
with Umlauts)
Any suggestions?
thx, vg
Steffen
More information about the TYPO3-dev
mailing list