Wrong Encoding Wrong Encoding
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Wrong Encoding

Started by Mike2421, March 18, 2019, 08:20:20 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Mike2421

Hi,

I have Coppermine version 1.5.42.

The database, table and fields are set to utf8_general_ci.

I am using Greek language for Categories and Album titles.

However the data in the fields where store in strange characters (i am attaching a screenshot of the db). An example is the below:

ΦΩΤΟÎ"ΡÎ'ΦΙΕΣ ΠΡΙÎ

Any idea why's that? Also is there any way or mysql query to fix those bad characters as they are stored in the db now?

Thank you so much in advance!

Αndré

As a test, please try to add
$CONFIG['dbcharset'] = 'utf8'
to include/config.inc.php. This will break your current category and album titles, comments or any other meta data which is stored in the database.

Now, try to add a new album / category or comment with greek characters and check if they are stored correctly in the database. If so, we can check how to fix the existing data.