Insert French Character to Table

[eluser]potatoDie[/eluser]
For me, changing the settings to utf8 of the database definition itself didn't work. But leaving the database collation at latin1_swedish_ci and using this also for the CI-settings (config/database.php) worked ok:

Code:

$db['default']['dbcollat'] = "latin1_swedish_ci";

I suppose any other latin would do, but not utf8?