CiviCRM Community Forums (archive)

Hmm, to make things even weirder, searching for "Jusinska" does work.
This has to do with the MySQL "collate" option that determines how strings are treated.

Can you check:

1- Does the quicksearch of CiviCRM work? i.e. the search box in the upper-left corner of the screen. I tried creating a contact with the same name, and it worked for me. (you can also try to reproduce on the demo site: http://joomla.demo.civicrm.org/administrator/).

2-  "Show create table civicrm_contact;" and see what kind of collate/charset it returns? For example:

show create table civicrm_contact;
[.... very long table description ..]
ENGINE=InnoDB [...] CHARSET=utf8 COLLATE=utf8_unicode_ci
In utf8_unicode_ci collate, mysql considers that "ń" and "n" are the same letter, so it explains why "Jusinska" would work, but does not explain why "Jusińska" does not.

Reference: http://stackoverflow.com/questions/3506338/mysql-and-polish-words

Warning: I do not recommend changing the "collate" of the table unless you really know what you are doing, but if you search on the topic, you will inevitably find some people who may recommend it. I suspect the problem is elsewhere, since I cannot reproduce the error on a demo site.

Can you try to reproduce the problem on the demo site with a profile? http://joomla.demo.civicrm.org/administrator/

(sorry I don't have time to do more tests locally, but if we can confirm that it's a bug with CiviCRM, and not the specific hosting/site, we can open a bug report and ask more people to look into it)

I managed to simulate the problem on the demo site, exactly in same steps as I get into it on my own page. So I created a Profile with only one field - Surname. Then I added an Individual person - Jusińska. Then I entered this link: http://joomla.demo.civicrm.org/administrator/index.php?option=com_civicrm&task=civicrm/profile&reset=1&gid=13

On your demo site, searching for "Jusińska" returns proper result, the same link on my site returns nothing.

So there must be a problem with my website configuration... Now what...?

Adding this code "mysql_set_charset('utf8');" at the bottom of civicrm.settings.php (in the components catalog) doesnt change anything.

But:

Just a few moment ago I have googled a similar problem (dated somewhen in 2009). The point (then and in my case as well) was to add in main joomla index.php this line: setlocale(LC_ALL, 'pl-PL.utf8', 'pl_PL.UTF8', 'pl_PL.utf8', 'pl_PL.UTF-8', 'pl_PL.utf-8', 'polish_POLISH.UTF8', 'polish_POLISH.utf8', 'pl.UTF8', 'polish.UTF8', 'polish-pl.UTF8', 'PL.UTF8', 'polish.utf8', 'polish-pl.utf8', 'PL.utf8');

That resolved the problem. I am not quite sure what I have done, because Joomla itself and SQL tables were already configured as UTF-8, but after adding the above line of code it all works now:)

Changing LC_ALL to LC_CTYPE works fine, still fixes the issue, thanks:)

However, the "native gettext" method returns proper value (jusińska) in search engine, but everything is back in English:( (looks like this fix could change the translation language back to English)

You are right - I made a mistake moving file civicrm.mo to the wrong catalog. Now, after modyfing civicrm.settings.php (both from administrator and components catalog) and moving file civicrm.mo, along to your instructions, all works fine! Thank you very much for your support!