2. PHPRunner General questions
  3. Configure the application to display the correct encoding of the text
This topic is locked

Configure the application to display the correct encoding of the text

 		12/26/2020 3:05:14 AM
PHPRunner General questions
A
 alfonso authorDevClub member

I have a table with enough data that its Character Set: latin-1 and Default Collation: latin1_swedish_ci

I have made a project to handle this table and the problem is that I see the wrong characters, the accents, for example, are stored like this in the table. for example:

  • Menú del día must be: Menú del día
    What do you advise me to do? Changing all the text in the tables would be laborious
  • What can I do in the project to continue working with these characters?

    In Templates->header.htm I have <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    Thanks for everything
M
 		MikeT 12/26/2020

I would advise to solve the problem at the source once and forever, otherwise this will bite you again and again

It's been a while since I had to do this, but there are plenty of ressources on the web (e.g. on stackoverflow) on how to do character encoding conversions in a database server.
Sergey Kornilov admin 12/28/2020

I agree, that fixing this on the database side is the way to go. I would suggest changing the database character set and the data itself to UTF8. Also make sure that UTF8 is selected as the output page encoding in the PHPRunner itself on Miscellaneous page.
D
 		danaci 12/28/2020

hi,

before export your datas to excel and recreate database

Character Set: utf8 and Default Collation: utf8_general_ci and import datas from phpmyadmin