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.

Problem after MySQL upgrade

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

  1. petfut

    petfut Well-Known Member

    Joined:
    Feb 14, 2005
    Messages:
    60
    Likes Received:
    0
    Trophy Points:
    6
    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

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

    http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html

    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

    Joined:
    Mar 14, 2003
    Messages:
    410
    Likes Received:
    0
    Trophy Points:
    16
    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!
     
Loading...

Share This Page