french caracters..

[techker]

hey guys i forgot what to set my database to when i want to insert éâ...

latin_switich_ci

or utf8_switich_ci

[Orjan]

latin should have support for those characters. utf8 has it without a doubt.

But I do not recognize those collations you mention at all? what is switich?

[Jordan]

I can say nothing more than what Orjan has already stated. I'm assuming you are working with MySQL?

[techker]

ya its mysql.its funny cause i never had that problem?

witch latin should i chose?or even utf8?

[Orjan]

I can't find a special french collation, and these days, I actually find it better to go with UTF8 normally, but then you need to make sure the application linked to the database also uses UTF8. the collation to use would probably be utf8_general_ci. If you want to keep with latin, it would be latin1_general_ci (ci stands for case insensitive. if you want case sensitive, choose a collation with cs instead)

[techker]

whats funny is that in my databse i changed the errors but on my page it shows still with the square instead of the é??

my page is coded

meta http-equiv="Content-Type" content="text/html; charset=utf-8"

[techker]

funny thing i just switch my encoding to ISO-8859-1 the forms showed all good!but the page it self was wrong now?the characters were not showing ok??

why is it the the drop down i did in php and mysql(gets data from databse) works but the rest is not good??