[TYPO3-english] Small question about DB encoding

[Dmitry Dulepov]

Hi!

Tapio Markula wrote:
> 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.

I think you have a collation problem. If you issue this sql: "show
variables like 'collation_%'", what does mysql answer to you?

-- 
Dmitry Dulepov
TYPO3 translations support
My TYPO3 book: http://www.packtpub.com/typo3-extension-development/book
In the blog:
http://typo3bloke.net/post-details/typo3_certification_launched/