Problem: Cannot find the uppercase non-latin letters
Problem description
I cannot find the non-latin-named company/contact by the name in the following places of the CRM app:
custom fields (CRM Company, CRM Contact, etc.)
text filters in the CRM directories (Companies, Contacts, etc.)
Example
CRM Company name = "Тест" (Cyrillic):
search by "Тест" → 0 results
search by "тест" → 0 results
search by "ест" → 1 result "Тест"
![](../../__attachments/3298820293/image-20230421-100512.png?inst-v=0ec633b7-7887-4011-80be-da1f370f2441)
![](../../__attachments/3298820293/image-20230421-100519.png?inst-v=0ec633b7-7887-4011-80be-da1f370f2441)
Background
Ask your system admin to check the database settings (at least the Postgres DB is affected). For the locale configuration recommended by Atlassian (documentation) the text search may not work correctly for specific symbols.
Solution
The system administrator should change the DB parameters as follows (for Postgres and Russian language):
From: ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'С'
To: ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'ru_RU.UTF-8'