I'm not able to view correct accent.
farÃ instead of farà
how to do?
You probably have a wrong encoding by the column with accented characters. Change the encoding to binary and then to the real encoding.
How to change the encoding to binary and then to the real encoding?
Thanks for the response and for the script fast and tiny.
Go to Alter table - encoding is displayed in column Options.
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.
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.
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?
No, Adminer supports UTF-8 only.