![]() |
|
Extended characters, UTF-8 and ISO Western European question - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: Extended characters, UTF-8 and ISO Western European question (/thread-3541.html) |
Extended characters, UTF-8 and ISO Western European question - pled - 2008-08-22 Hello, After upgrading to 1.2 version, I have noticed some changes in my album. I know my configuration was probably wrong earlier, but I only need to understand what is means : Before upgrade, although I was set to UTF-8, I could not use the on-browsing Ajax editor : extended french characters were wrongly stored. All was fine using the admin editing page. Now, using 1.2, and selecting French during upgrade, I set UTF-8 too, bull all my text (description, comments) from previous albums had extended characters badly displayed when browsing. But I was able to use Ajax editor... I had to change settings to ISO Western European language to get all the text from previous albums displayed as expected. I understand that previous albums were wrongly strored for some reasons, probably me. Thanks, Extended characters, UTF-8 and ISO Western European question - pled - 2008-08-28 I try to formulate this in another way : Is there a way to migrate existing albums created with ISO Western European setting to UTF-8 ? Thank you. Extended characters, UTF-8 and ISO Western European question - sbillard - 2008-08-28 You would have to export all the database data, then change the database to UTF-8, then re-import the data after converting it to UTF-8. Extended characters, UTF-8 and ISO Western European question - pled - 2008-09-04 Thank you for replying. I may have found what was wrong in my database settings : looking at phpMyadmin home page on my internet provider (and comparing to my local database), I found the following differences :
I am a little bit stressed to perform export/import... ;-) afraid to loose the data ! (in disaster/recovery scenarios, the problems always come with the recovery phase !! and it is too late). I will then try to reproduce the case on my local installation, then if it works fine, I will do it on the online album, being more confident. Extended characters, UTF-8 and ISO Western European question - pled - 2008-09-28 Hello, In case that helps some other people : The issue is fixed now (after some local tests). I did an export from MySQLAdmin, but only relevant tables, that are : zen_albums, zen_comments and zen_images. Now having all my settings (database, zenphoto) set to utf8, I can browse all my previous albums and all is displayed correctly. And I can use the on-line editor as well. So all is fine now. |