Page 1 of 1

A question about db_charset, db_collation, etc.

Posted: Fri 18. Apr 2008, 16:54
by 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:

Image

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.

Re: A question about db_charset, db_collation, etc.

Posted: Fri 18. Apr 2008, 17:25
by Jensensen
[x]

Re: A question about db_charset, db_collation, etc.

Posted: Fri 18. Apr 2008, 18:43
by 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).

Re: A question about db_charset, db_collation, etc.

Posted: Fri 18. Apr 2008, 21:50
by Jensensen
[x]

Re: A question about db_charset, db_collation, etc.

Posted: Fri 18. Apr 2008, 23:54
by sustia
Hi Jensensen, for now I don't have disposable vegetables :mrgreen:

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 :wink: )

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).

Re: A question about db_charset, db_collation, etc.

Posted: Sat 19. Apr 2008, 00:11
by update
Very beautiful scenery :)