phpwcms Support Forum

I just read Oliver's post and notes about the db collation options
http://www.phpwcms.de/forum/viewtopic.php?t=13890

I must admit I am a bit puzzled about all this collation stuff

Right now I am working on a new 1.2.9 site.
All is running fine.
Here are the collation confs I have in there:

In my CONFS I have:
$phpwcms['db_charset'] = 'latin1';
$phpwcms['db_collation'] = 'latin1_swedish_ci';
$phpwcms['db_version'] = 40121;

In PhpMyAdmin:
I can see that all the tables have their collation set to this: latin1_swedish_ci
just like all the other programs' dbs I have in there running

Existential Question:
Does it makes sense that someday at some point and for a reason I would not yet suspect, I would then have to change or swap all the tables collation settings from latin1_swedish_ci to utf8_unicode_ci

Important (to me):
What would then be the SQL command to batch swap all the tables collations from latin1_swedish_ci to utf8_unicode_ci ?


Just a matter of starting this site the good way before too many texts get published.

Cheers,

Yves
Sincere PhpWCMS Evangelist

Was this a dummy question?
Am I the only one around here puzzled about collation ?
I really need to push away that cloud over my head

Cheers,

Yves

For the languages you speak ... there is no need to switch to UTF-8. So don't think about.

But it's very transparent in MySQL now - as long as you set correct phpwcms db connection charset/collation settings there is NO need to convert db tables too. MySQL will do it for you on the fly then.

Oliver

Yé !!!
No more clouds
Thank you Oliver for taking the time

Cheers,

Yves

One note: on the fly just means charset conversion for current db connection - but NOT converting db tables.

Oliver

Oliver,

What I understand is that in my context,
where I mostly work with French and English
and Spanish (maybe some day?), I am allright with these settings:
$phpwcms['db_charset'] = 'latin1';
$phpwcms['db_collation'] = 'latin1_swedish_ci';

... and if ever some day... a client ask me for a Japan and English Web Site,
then... I will have to use these instead:
$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_general_ci';
In this case, I suppose I will have to make sure all the tables are set to utf8_general_ci

Cheers,

Yves

yes. that's right! Good boy

Oliver

doing my best