ISPconfig Default DB Character Set for Sites

Hi, I noticed that the default character set for the databases that ISPconfig creates is "latin1_swedish_ci".

My question is, which is the file that is responsible for the default character set of the databases created by ISPconfig ?

All I need is to turn it to use "utf8_general_ci" as default.

anyhelp ? thanks alot in advance.

 

hm yeah you are right,

.. the thing is that i found nothing in that file having to do with the character set

 

Take a look here: http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html

 

for anybody who want's to know

1und1 use this settings (as i can see - no guarantee )

/etc/mysql/my.cnf

Code:

[mysqld]
collation_server=utf8_general_ci
character_ser_server=utf8