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
Let's see a link to your gallery for a start.
Here (http://www.fragrancias.info/gallery/index.php) it is.
Thks
Are the pictures table and the individual fields in the pictures table utf8_unicode_ci also?
That tables is, but the fiels are in utf8_bin, I did tryied to change utf8_unicode_ci but I got this error:
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
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?
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.
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
Afaik: no.
ok. Thank you very much for your help :)