Print Page - Upgrade CPG database from mysql4 to mysql5

Title: Upgrade CPG database from mysql4 to mysql5
Post by: mainpower on December 31, 2006, 03:30:14 PM

Did anyone do an upgrade of their DB to MYSQL 5 ???

By default MYSQL is using utf8 and I did a import of the MYSQL4 export with phpmyadmin (latest version).
The database looks okay .. only now I have some strange characters like:

Pic015-VÃ¶lkerschlachtdenkmal (Battle of the Nations Memorial).jpg (this is the output)
Pic015-Völkerschlachtdenkmal_(Battle_of_the_Nations_Memorial).jpg (this is in the database)

Therefor the picture is not displayed...

Title: Re: Upgrade CPG database from mysql4 to mysql5
Post by: mainpower on December 31, 2006, 04:00:15 PM

Solved .. you have 'of course' change the "Character encoding" settings in the config ... ::)

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: mainpower on December 31, 2006, 03:30:14 PM