ISPconfig Default DB Character Set for Sites

Discussion in 'Installation/Configuration' started by orasis, Mar 18, 2007.

  1. orasis

    orasis Member

    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.
     
  2. till

    till Super Moderator

    This is not set in a config file of ISPConfig, it si set in the my.cnf config file of your mysql installation.
     
  3. orasis

    orasis Member

    hm yeah you are right,

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

    falko Super Moderator

  5. vogelor

    vogelor ISPConfig Developer

    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
    
     

Share This Page