• Mario Pilesi

    Mario Pilesi - 2010-05-23

    I'm not able to view correct accent.
    farà instead of farà
    how to do?

  • Jakub Vrána

    Jakub Vrána - 2010-05-24

    You probably have a wrong encoding by the column with accented characters. Change the encoding to binary and then to the real encoding.

  • Mario Pilesi

    Mario Pilesi - 2010-05-24

    How to change the encoding to binary and then to the real encoding?
    Thanks for the response and for the script  fast and tiny.

  • Jakub Vrána

    Jakub Vrána - 2010-05-24

    Go to Alter table - encoding is displayed in column Options.

  • Eagle53

    Eagle53 - 2010-12-27

    I enter Alt-130, which gives me é. In Admin database view, it appears as pérez. In Excel 2007 it appears as Pérez. Should be pérez
    On my website these values all show up correctly. When I use AdMiner, they are scrambled. They continue to be scrambled when I Export to CSV and open file with Excel. When I do a CSV Inport, the codes then show up "mixed" on website. In AdMIner, the Table Option values being used is latin1_swedish_cl.
    Thank you for anu suggestions.

  • Jakub Vrána

    Jakub Vrána - 2010-12-27

    You have probably saved the value in UTF-8 encoding without specifying the encoding by SET NAMES or SET CHARACTER SET.

    In your application, you have to call one of these commands after connecting to the server.

  • Nobody/Anonymous


    I am having the same problem with MSSQL. Is there any way to change the encoding of the adminer so we can insert values in the db without changing carecter encoding?


  • Jakub Vrána

    Jakub Vrána - 2011-05-04

    No, Adminer supports UTF-8 only.


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks