coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Quinti on October 10, 2006, 01:57:43 PM

Title: how read keywords in iso-8859-1?
Post by: Quinti on October 10, 2006, 01:57:43 PM
Hi All

i'm using iso-8859-1 in my gallery: http://www.fotosdesarria.com (http://www.fotosdesarria.com).
in the search.php page, no show these iso-8859-1 characters (áéíóúñ) http://www.fotosdesarria.com/search.php (http://www.fotosdesarria.com/search.php)

and the search no produce results, for example, in where must be "ampliación" puts "ampliacin" and the search is null: http://www.fotosdesarria.com/thumbnails-search-ampliacin.html (http://www.fotosdesarria.com/thumbnails-search-ampliacin.html) = "No image to display"

how i can solve this?
1 - editing manually all the keywords that containing iso-8859-1 characts?
2 - putting my gallery in utf-8?, but i can't do that, because the people comments will no showing correctly....

are there any alternative?

bajj, sorry for my english...
thank u very very much
Title: Re: how read keywords in iso-8859-1?
Post by: Joachim Müller on October 10, 2006, 11:57:01 PM
Quote from: Quinti on October 10, 2006, 01:57:43 PM2 - putting my gallery in utf-8?
Yes, use utf-8

Quote from: Quinti on October 10, 2006, 01:57:43 PMbut i can't do that, because the people comments will no showing correctly....
Erm, what? You'll need to convert your existing comments and everything should be fine.
Title: Re: how read keywords in iso-8859-1?
Post by: Quinti on October 11, 2006, 12:30:05 AM
thanks

but, how i convert the comments in utf-8?

and the new comments? if is in utf-8, and i add this comment expample: "Está chévere ché"
no will show correctly...no?
Title: Re: how read keywords in iso-8859-1?
Post by: Joachim Müller on October 11, 2006, 12:35:37 AM
charsetmgr.php
Title: Re: how read keywords in iso-8859-1?
Post by: Quinti on October 11, 2006, 12:57:58 AM
oukis

then, when a new comment is added, i need use the converter?

solved then

thanks
Title: Re: how read keywords in iso-8859-1?
Post by: Joachim Müller on October 11, 2006, 04:30:59 AM
Set your gallery offline to avoid new comments being posted during your administration changes. Then set your encoding to utf-8 (unicode) in coppermine's config. Next, use charsetmgr to convert your existing textual content inside your database to utf-8. It's advisable to create a backup (mysql dump) of your database before converting in case anything goes wrong. Finally, set your gallery back online. All subsequent comments will be in utf-8, you you won't have to convert anything again. Even comments posted in languages you normally don't use (like chinese or hebrew) would be displayed correctly - your gallery would truely be mutlilingual.