Page 1 of 1
please advice special characters UTF8??
Posted: Mon Sep 15, 2008 3:15 pm
by 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!!
Re: please advice special characters UTF8??
Posted: Tue Sep 16, 2008 8:02 am
by alby
hugosnel wrote:
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
Re: please advice special characters UTF8??
Posted: Tue Sep 16, 2008 8:52 am
by hugosnel
all tables?
one by one?
by hand?
is there a mysql script for doing this?
Thank you, merci, gracias
Re: please advice special characters UTF8??
Posted: Tue Sep 16, 2008 8:58 am
by alby
hugosnel wrote:
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