[Solved]: Search problem

[Kayleigh]

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

[Joachim Müller]

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

[Kayleigh]

Here it is.

Thks

[Nibbler]

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

[Kayleigh]

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 Expand

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

[Kayleigh]

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?

[Nibbler]

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.

[Kayleigh]

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

[Joachim Müller]

Afaik: no.

[Kayleigh]

ok. Thank you very much for your help