[TYPO3-english] Small question about DB encoding

Tapio Markula tapio.markula at xetpoint.fi
Thu Nov 13 21:02:28 CET 2008


Victor Livakovsky kirjoitti:
> Hi, List.
> 
> I have set all necessary settings for using utf-8 encoding at client's
> server. Everything is ok, except one thing: non-latin characters
> aren't kept in DB as, they should be kept.
> 
> I've executed: SHOW VARIABLES;
> and have seen that all encodings are utf8, except:
> character_set_server    latin1
> collation_server        latin1_swedish_ci


I have utf-8 related problem too.
Listing address would need some onfly conversion and ordering so that
A*A"O" would be rendered aftex Y
not like

Aaltonen
O"berg
A*lund
Allberg

but


Aaltonen
Allberg
A*lund
O"berg

because in utf8 names, which start with A* and O" are stored so that they 
start with accented A.


More information about the TYPO3-english mailing list