utf-8 in ispconfig database

Discussion in 'Developers' Forum' started by guardian, Nov 25, 2008.

  1. guardian

    guardian Member

  2. till

    till Super Moderator

    Please try to change the encoding of the database and all tables to utf-8, does it work then?
  3. guardian

    guardian Member

    I have change db encoding and encoding for table client and the problem still exist.

    I forgot to mention that when you try to edit client all is displayed correctly.
  4. till

    till Super Moderator

    What is the problem if everything is displayed correctly when you edit the client?
  5. guardian

    guardian Member

  6. till

    till Super Moderator

    Ok, that has nothing to do with the charset of the mysql database then. Most likely there is a conversion issue in the php class that creates the lists.
  7. vogelor

    vogelor ISPConfig Developer

    i think, changing the encoding of the db is not enought!
    you also have to change the encoding of the data itself!

    i think "set "fieldname" = utf8(fieldname)" or somthing like this. read the mysql manual and try this - maybe this helps

  8. radim_h

    radim_h Member

    same problem with czech characters

    I have same problem

    MySQl is set to utf-8, in /etc/mysql/my.cnf
    port = 3306
    socket = /var/run/mysqld/mysqld.sock
    default-character-set = utf8

    default-character-set = utf8
    character-set-server = utf8
    collation-server = utf8_czech_ci
    default-collation = utf8_czech_ci

    When editing client, everything is shown correctly

    On client overview page it is not:

    And in phpmyadmin, there is also chaos

    BTW: behaviour in ISPC2 is same i can see correct characters in administration, but not in Mysql database
  9. guardian

    guardian Member

    Revision 624 fixed the problem. Thanks.
  10. radim_h

    radim_h Member

    Please, how should i update SVN installation of ISPC3 to last revision ?
  11. guardian

    guardian Member

    cd /tmp
    svn export svn://svn.ispconfig.org/ispconfig3/trunk/
    cd trunk/install
    php -q update.php
  12. till

    till Super Moderator

    Or run the following comamnd on the shell:

  13. radim_h

    radim_h Member

    will it overwrite my own language files as i'm allmost finished with translating ISPC3 to Czech. ?

    If so, what is the best way to backup language before update ?

    Actually how should i backup ispconfig before update in case something goes wrong? Is it enough to backup directory /usr/local/ispconfig and database ??
    Last edited: Dec 1, 2008
  14. till

    till Super Moderator

    The Update overwrites all files. But you can use the import and export functions of the ispconfig language file editor to make a backup of your language file and restore it afterwards.
  15. radim_h

    radim_h Member

    Are languages really overwrited with new ones thru update?

    I'd like just to check for info:

    was there any change in language files in ISPConfig from last version?

    I'd like to know if file /usr/local/ispconfig/interface/web/monitor/lib/lang/en.lng in ISPConfig contains string "$wb['Show RKHunter-Log']"

    as after update this item is missing in language file. Just want to be sure that language files are overwrited during update and merge will be working
    (i suppose this string just wasnt added,
    rkhuter is example that was first new item i have noticed after update)


    UTF8 problemis fixed.
  16. vogelor

    vogelor ISPConfig Developer

    that's right.
    i am actually doint heavy develpoment on the monitor - module. i liked to implement the rkhunter some days ago but haven't much time.

    so rkhunter is "removed". last weekend i had the time, so rkhunter is added again ;-)
  17. radim_h

    radim_h Member

    so the answer is - i have not to worry, it wasnt included in the lang file? .o)
  18. vogelor

    vogelor ISPConfig Developer

    YEP! you are right

Share This Page