please advice special characters UTF8??

[hugosnel]

Hello,Help!
I need to set up CMS for french sites with lots of special characters.
The standard istall sets up all tables in latin1_swedish_ci
Do I need to change something to have all tables in utf8-unicode-ci???
Is this a correct solution for me?
Please advice!!

[alby]

I need to set up CMS for french sites with lots of special characters.
The standard istall sets up all tables in latin1_swedish_ci
Do I need to change something to have all tables in utf8-unicode-ci???
Is this a correct solution for me?

Install don't set your DB encoding
You must set utf8-unicode-ci in your DB, this after create new tables and fields in utf8-unicode-ci
Set with a SQL tool (ex: phpmyadmin)

Alby

[hugosnel]

all tables?
one by one?
by hand?
is there a mysql script for doing this?
Thank you, merci, gracias

[alby]

all tables?
one by one?
by hand?
is there a mysql script for doing this?
Thank you, merci, gracias

There are scripts (search with google or in mysql site) or if it's a new installation, drop all tables, change to utf and reinstall

Alby