| Re: Encoding Problem on a site display |
| by user2222 on 2019/2/7 12:20:29 Hi Mamba, Thank you for your replay. I will update my database accordingly. Regards. Eddy |
| Re: Encoding Problem on a site display |
| by Mamba on 2019/2/6 15:45:58 In MySQL you should be using: utf8_general_ci On the PHP side: UTF8 You can use this script to convert your MySQL to UTF8, see this thread: https://xoops.org/modules/newbb/viewtopic.php?post_id=352633#352633 |
| Encoding Problem on a site display |
| by user2222 on 2019/2/6 14:53:57 Hi everyone, Thank you for reading the following display problem, on my site. 1 - I have reinstalled a site that stoped a few years ago. Everything works fine, except the display of some characters, on many modules. On the following page, you will see the encoding problems Forum with encoding problem . 2 - Here are the technical characteristics. Linux deb8u1 PHP 5.6.36-0+deb8u1 Mysql 5.5.60 3 - What I made. I tried to change the encoding using the phpmyadmin tool. I tried the following encodings, either on the table, or on the connection and database collation. latin1_swedish_ci (the recommended encoding for tables) utf8_general_ci latin1_general_cs I also changed the secure.php file (in xoops_data/data folder). // define('XOOPS_DB_CHARSET',''); // define('XOOPS_DB_CHARSET', 'UTF8'); // define('XOOPS_DB_CHARSET','latin1'); // define('XOOPS_DB_CHARSET','ISO-8859-1'); But all of this does not work. There may be another was to resolve this encoding problem. I tried many solution but none is working. I need the help of an specialist who could give me valuable information on encodings. There are some changes in the page, but are a still some special characters. Please, what is your advice on this ? Thank you very much for your advice. Kind Regards Eddy Cingala |