how read keywords in iso-8859-1? how read keywords in iso-8859-1?
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

how read keywords in iso-8859-1?

Started by Quinti, October 10, 2006, 01:57:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Quinti

Hi All

i'm using iso-8859-1 in my gallery: http://www.fotosdesarria.com.
in the search.php page, no show these iso-8859-1 characters (áéíóúñ) 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 = "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

Joachim Müller

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.

Quinti

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?

Joachim Müller


Quinti

oukis

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

solved then

thanks

Joachim Müller

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.