Problems with danish language and keywords

[TerraNaut]

Hi,

I've got this problem with my keywords. Because my gallery is in both english and danish i use both languages for my keywords (ie. 'horse' and 'hest') for my pictures.

Because the danish language have 3 characters which are speciel (æ ø å) my keywords don't work.

Example:

The picture http://www.terranaut.dk/billeder/displayimage.php?pos=-6233 have the keyword 'røg' (which means smoke) but if I make a common search of it using 'røg' it won't show up. In the keyword list it has been changed to 'rg' ( http://www.terranaut.dk/billeder/search.php ). Now comes the funny part. If I log on as administrator and check the keyword list - it's spelled 'røg'?

Any idea how to fix this? I've tried to set my gallery to both english and danish (also the character setting) but with no luck. I've have just upgraded to the stable version 1.4.19

I've noticed the problem when I started to use the keywords in a larger scale, so I presume that the problem/challenge have been there all the time.

Thanks TerraNaut

[Joachim Müller]

Well, you tampered with the encoding of coppermine, which is baaaad. By default, coppermine uses utf-8 encoding for very good reasons. Keeping that encoding is recommended unless you really know what you're doing (see documentation). In fact, I can't really think of any reason to use another encoding than utf-8 at all. You asked for problems by switching the encoding from utf-8 to is8859-1, which was a silly move. You ignored all warnings in the docs. Now the textual content of your database is iso8859-1 driven and not in utf-8, so you can't easily go back by just changing the encoding settings in coppermine's config. What you will need to do is convert your textual content in your database to unicode. This has been discussed previously, please search the forum for previous discussions.

[TerraNaut]

Hi Joachim,

Thanks for the fast reply and the solution. Hmmm, I must have changed the encoding years ago... Nevertheless it seems to work. All I have to do is to change the three speciel characters (which now are boxes) to the correct danish character. It will take some time, but I'm going through all my keywords anyway so its okay (and the characters are not so common after all).

[TerraNaut]

Just for the information - this problem is solved, so the thread can be closed with the tag [Solved] 

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631