forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Kayleigh on May 03, 2008, 10:39:14 pm

Title: [Solved]: Search problem
Post by: Kayleigh on May 03, 2008, 10:39:14 pm

Hi,

I hope somebody can help me. I'm creating a gallery and all is working fine, except the search.

I search the forums and didn't find the solution to the problem, tryied google and didn't have an answer.
I did read in the forums that Coppermine isn't Case Sensitive by default, but I didn't change anything and in my gallery it is case sensitive. My gallery is cpg1.4.18, it's on Linux server and the collation in my database is utf8_unicode_ci. In the same host I have a forum, and the search is case insensitive.

I'm trying to find a solution for this, anyone knows how to solve? please


Thks

Title: Re: Search problem
Post by: Joachim Müller on May 03, 2008, 11:09:28 pm

Let's see a link to your gallery for a start.

Title: Re: Search problem
Post by: Kayleigh on May 03, 2008, 11:16:57 pm

Here (http://www.fragrancias.info/gallery/index.php) it is.

Thks

Title: Re: Search problem
Post by: Nibbler on May 03, 2008, 11:22:56 pm

Are the pictures table and the individual fields in the pictures table utf8_unicode_ci also?

Title: Re: Search problem
Post by: Kayleigh on May 03, 2008, 11:39:00 pm

That tables is, but the fiels are in utf8_bin, I did tryied to change utf8_unicode_ci but I got this error:

Code: [Select]

ALTER TABLE `cpg14x_pictures` CHANGE `caption` `caption` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL

Mensagens do MySQL : 

#1283 - Column 'caption' cannot be part of FULLTEXT index

Title: Re: Search problem
Post by: Kayleigh on May 04, 2008, 12:19:22 am

I tryed again to change the collation on the fields and now all are utf8_unicode_ci and now I can do the search for "sempa" or "Sempa" and got results. Thanks for the tip  :)
But in my language we have words like: bicafé, café, identificação... and if I write cafe, bicafe or identificacao I have no results. That is not related to the collation?

Title: Re: Search problem
Post by: Nibbler on May 04, 2008, 12:53:31 am

I don't think so. I don't know about Portuguese, but in many languages the diacritics should not be ignored in a search. For example, in German schön is not the same as schon.

Title: Re: Search problem
Post by: Kayleigh on May 04, 2008, 06:29:51 pm

In portuguese, we do have words like that. But some people tend to forget that. There is no way to make the search report words with an "é" and a "e", for example?

Thks

Title: Re: Search problem
Post by: Joachim Müller on May 06, 2008, 07:45:55 am

Afaik: no.

Title: Re: Search problem
Post by: Kayleigh on May 06, 2008, 02:07:02 pm

ok. Thank you very much for your help  :)