Advanced search  

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]

Pages: [1]   Go Down

Author Topic: how read keywords in iso-8859-1?  (Read 3550 times)

0 Members and 1 Guest are viewing this topic.

Quinti

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 79
    • Quinti.net
how read keywords in iso-8859-1?
« on: October 10, 2006, 01:57:43 pm »

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

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: how read keywords in iso-8859-1?
« Reply #1 on: October 10, 2006, 11:57:01 pm »

2 - putting my gallery in utf-8?
Yes, use utf-8

but 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.
Logged

Quinti

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 79
    • Quinti.net
Re: how read keywords in iso-8859-1?
« Reply #2 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?

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: how read keywords in iso-8859-1?
« Reply #3 on: October 11, 2006, 12:35:37 am »

charsetmgr.php
Logged

Quinti

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 79
    • Quinti.net
Re: how read keywords in iso-8859-1?
« Reply #4 on: October 11, 2006, 12:57:58 am »

oukis

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

solved then

thanks

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: how read keywords in iso-8859-1?
« Reply #5 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 17 queries.