After upgrading from 1.2.1 to 1.4.10 charset is annoying

[Gabriel Menini]

Hello, there.

I've recently upgraded from v. 1.2.1 to 1.4.10 following the steps published here http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#13.

Everything is fine but the language/charset issue. My gallery default language is Spanish. Using utf-8 charset I get the album names (and file names, too) with altered characters  :-\. If I switch to the "default-language-file" or "iso-8859-1" the album and file names remain OK but the title of the gallery and the sub-title show invalid characters. 

Anyone have had the same problem?  :'(

Thanks in advance.

[Joachim Müller]

Return to utf-8, then run charsetmgr.php to convert the textual content of your database to utf-8. This step is being suggested during the upgrade stage, you should have read the text at the bottom.

[Gabriel Menini]

Return to utf-8, then run charsetmgr.php to convert the textual content of your database to utf-8. This step is being suggested during the upgrade stage, you should have read the text at the bottom.

Thanks, GauGau.
I wasn't able to find the step you mention on http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#13. Anyway, followed the steps you suggested (leaving the language to utf-8) and on http://mysite/coppermine/charsetmgr.php I am warned to leave the page because I don't have to change anything.... I see two combo boxes with the 'utf-8' option selected. I click on check and then the second stage throws an error:

Fatal error: Call to undefined function: iconv() in /filesystem/path_to_coppermine/charsetmgr.php on line 76

[Joachim Müller]

This means that you don't have iconv on your server, so you can't do the conversion automatically using charsetmgr. You have two options then: stick with your old encoding or convert the content of the database manually (dump, then re-import after converting it).

[Gabriel Menini]

Errr...

What do you mean by

dump, then re-import after converting it

?
I can dump a table or a group of tables and then how can I convert them and reimport? 

[Joachim Müller]

There are various tools to convert textual content from one encoding to the other. Personally, I use Uni2Me (Download link: http://alf-li.pcdiscuss.com/files/uni2me10.zip). Don't be afraid of the chinese chars on that page, the tool itself is in English.