forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Mike2421 on March 18, 2019, 08:20:20 pm

Title: Wrong Encoding
Post by: Mike2421 on March 18, 2019, 08:20:20 pm

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!

Title: Re: Wrong Encoding
Post by: Αndré on April 09, 2019, 12:46:27 pm

As a test, please try to add

Code: [Select]

$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.