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