The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql 4.1 wrong char

Discussion in 'General Discussion' started by adapter, May 27, 2006.

  1. adapter

    adapter Well-Known Member
    PartnerNOC

    Joined:
    Sep 17, 2003
    Messages:
    391
    Likes Received:
    0
    Trophy Points:
    16
    Hi

    i have upgrade my server from mysql 4.0 to 4.1 but now a lot of site display a wrong text, all the letter with à è ù are as "ù " how can i fix this problem?

    Thanks
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Try adding

    Code:
    [mysqld]
    init-connect=SET NAMES binary
    to my.cnf

    Then restart mysql.
     
  3. adapter

    adapter Well-Known Member
    PartnerNOC

    Joined:
    Sep 17, 2003
    Messages:
    391
    Likes Received:
    0
    Trophy Points:
    16
    I have try with init-connect=SET NAMES utf8 but i still have the same error
     
  4. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    UTF-8 won't work, because those characters are ISO. Did you try "binary"?
     
  5. dyrer

    dyrer Active Member

    Joined:
    Jun 3, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    which one my.cnf i have /etc/my.cnf and /user/local/cpanel/whostmgr

    My joomla installation creates latin1_swedish_ci collation
     
    #5 dyrer, May 28, 2006
    Last edited: May 28, 2006
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    /etc/my.cnf

    latin1_swedish_ci collations are exactly why utf-8 won't work. Unless you want to convert your database to utf-8, which could be messy if there are special keys within the database.
     
  7. dyrer

    dyrer Active Member

    Joined:
    Jun 3, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    how can convert it?
    is this needed ?
    init-connect=SET NAMES binary
     
Loading...

Share This Page