Insert French Character to Table

[eluser]Unknown[/eluser]
[quote author="tonanbarbarian" date="1289302919"]latin1_swedish_ci collation on the database would probably not support any accents or whatever is used in your french characters

best best is to convert the table, and all of the text fields in it, to utf8_general_ci, but be aware any existing records may not be updated[/quote]
I have tried to utf8_general_ci but characters are truncated on special character.

For example :
should be : simplexà gérer
but on database : simplex

Plus on latin1_swedish_ci strangely my non-CI code can insert correctly, so probably i don't need to alter the table.