strange visualization for special character

Discussion in 'Databases' started by stefanocps, Mar 16, 2018.

  1. #1
    hello i run a biblioteque site
    http://www.bibliotecaarpad.net/online/opac_css/index.php?
    and after updating all the caracter with accent are displayed weird
    I tried to alter the whole db charset to utf8 ..no result
    I tried to change manually the table (those interested are 4,5) and it was ok, but some data was lost
    so i reimport only data in my db, and while the table was still in utf8 data are back and also error
    don t know how to solve it
    i am thinking i could be happy even with just replacing the character with the proper using a command within my db in phpmyadmin
    but i don t know how is the command
    can you please help?
    thanks a lot!
     
    Last edited by a moderator: Mar 17, 2018
    stefanocps, Mar 16, 2018 IP
  2. akhileshbc

    akhileshbc Active Member

    Messages:
    98
    Likes Received:
    1
    Best Answers:
    5
    Trophy Points:
    75
    #2
    I think it would be better if you can post the exact error message so that we could provide you a better solution.

    Also, please take a look at your mysqldump (which you tried to reimport). It might have some command that is setting the collation to something else that utf.
     
    akhileshbc, Apr 29, 2019 IP