[TYPO3-english] value mismatch with fieldtype

[Dmitry Dulepov]

Hi!

Historia wrote:
> Is there any possibility to set up the database from the beginning to
> the right collation.

Configure MySQL to use UTF-8 as default character set. Alternatively you 
can use "ALTER DATABASE dbname DEFAULT CHARACTER SET utf8" to change it. 
You need to invoke this after the database is created but before tables are 
created.

Btw, collation does not cause the error you describe, it is character set 
that makes the problem. Collation only affects sorting of results while 
character set limits what characters can be stored.

-- 
Dmitry Dulepov
TYPO3 core&security team member
E-mail: dmitry.dulepov at typo3.org
Web: http://dmitry-dulepov.com/