[TYPO3-english] value mismatch with fieldtype

[Historia]

Hello Dmitry,

I did something like that. I exported the database with drop table and 
exchanged in the sql "charset=latin1" with "charset=utf8 character set 
utf8" and imported it again.

That works also with an already filled database. Thanks for the 
explanation of the collate. That helps.

Am 11.03.2011 14:15, schrieb 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.
>