A question about db_charset, db_collation, etc.

[sustia]

Hi, I'm a little confused about db_charset, db_collation, ecc.

I would like to do a personal site about my travels, so I need to put names in italian, spanish, english, iceland language, etc.

In my phpmyadmin I see this one:



and, in my conf.inc.php I have:

Code: Select all

$phpwcms['db_charset']        = 'latin1';
$phpwcms['db_collation']      = 'latin1_general_ci';


$phpwcms['charset']           = 'iso-8859-1';  //default charset 'iso-8859-1'

So I think I should change something, correct?
Maybe in my conf.inc.php I must put this values?

Code: Select all

$phpwcms['db_charset']        = 'utf8';
$phpwcms['db_collation']      = 'utf8_unicode_ci';


$phpwcms['charset']           = 'utf8';  //default charset 'iso-8859-1'

Thanks.

[Jensensen]

[x]

[sustia]

Ok Jensensen, thanks a lot.

I've modified my conf.inc.php to this:

Code: Select all

    $phpwcms['db_charset']        = 'utf8';
    $phpwcms['db_collation']      = 'utf8_unicode_ci';

    $phpwcms['charset']           = 'utf8';  //default charset 'iso-8859-1'

in order to prevent problems with some strange characters (like, for example, Vatnajökull).

[Jensensen]

[x]

[sustia]

Hi Jensensen, for now I don't have disposable vegetables

Anyway, I already see the Iceland, tha last octuber, and I'm planning to put online that and some more trip I've done (not too much trips )

If you want to see something about Vatnajökull glacier (and Iceland in general) maybe you will find interesting this pictures:

http://flickr.com/photos/sustia/1707335241/
http://flickr.com/photos/sustia/1743259960/

Others will follow soon (I hope).

[update]

Very beautiful scenery