xoops forums

user2222

Just popping in
Posted on: 2/6 14:53
user2222
user2222 (Show more)
Just popping in
Posts: 6
Since: 2007/1/22
#1

Encoding Problem on a site display

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

Mamba

Moderator
Posted on: 2/6 15:45
Mamba
Mamba (Show more)
Moderator
Posts: 10770
Since: 2004/4/23
#2

Re: Encoding Problem on a site display

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
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

user2222

Just popping in
Posted on: 2/7 12:20
user2222
user2222 (Show more)
Just popping in
Posts: 6
Since: 2007/1/22
#3

Re: Encoding Problem on a site display

Hi Mamba,

Thank you for your replay. I will update my database accordingly.

Regards.
Eddy