Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

mysql encoding issues

  • 08-08-2007 4:51pm
    #1
    ConsultClifford
    Registered Users, Registered Users 2 Posts: 252 ✭✭


    Hi

    I have a php mysql site working perfectly on one server

    i transfered over the site to another server - i changed nothing - and all the foreign characters are messed up - here is what i get 
    Nouveau programme Beta lancé pour l'année 2006
    instead of
    Nouveau programme Beta lancé pour l'année 2006

    tnx
    sean


Comments

  • #2
    forbairt
    Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭forbairt


    How did you go about transferring the mysql database ? are they both running the same versions ?


  • #3
    seamus
    Registered Users, Registered Users 2 Posts: 68,317 ✭✭✭✭seamus


    You can check the collation/character set on the tables first off:
    show table status from db_name

    The "Collation" column will tell you what's being used.

    Try resetting the collation on the database;
    ALTER DATABASE db_name CHARACTER SET latin1 COLLATE latin1_general_ci;

    This sets it to ISO 8859-2 (Western European Standard).


Advertisement