1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

strange visualization for special character

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

  1. #1
    hello i run a biblioteque site
    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

    Likes Received:
    Best Answers:
    Trophy Points:
    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