Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problem after MySQL upgrade

Discussion in 'Database Discussion' started by petfut, Nov 16, 2005.

  1. petfut

    petfut Well-Known Member

    Feb 14, 2005
    Likes Received:
    Trophy Points:
    All is working well after upgrade, except this problem.
    Looks like some foreign signs like: å, ä, ö etc are not functiong if I import or export a SQL file. It just shows some weird signs like: ä, ö etc.

    What might be wrong?
    SQL version is 4.1.13-standard
  2. cbwass

    cbwass Well-Known Member

    Mar 29, 2002
    Likes Received:
    Trophy Points:
    MySQL 4.1.x does not support accents in data base, table column names etc.

    If you have used accent characters (characters with byte values of 128 to 255) in database names, table names, constraint names, or column names in versions of MySQL earlier than 4.1, you cannot upgrade to MySQL 4.1 directly, because 4.1 uses UTF8 to store metadata names. Use RENAME TABLE to overcome this if the accent character is in the table name or the database name, or rebuild the table.
  3. jeroman8

    jeroman8 Well-Known Member

    Mar 14, 2003
    Likes Received:
    Trophy Points:
    I have also this problem, have had 5-6 clients with issues now.
    The come from 3-4.0 to our 4.1 and all characters (foreign) is ? instead.

    Rebuild the table ?

    Is there an easy tutorial we can give our clients or a way for us to fix this beofree or after it has been imported ?

    Step by step guide :)

    I would love it and it would be much appreciated!

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice