I use views exposed filter as search string with "contain" operator. The filter works normally, but somewhy does not work with cyrillic symbol 'й' if it is placed at end of a word (so it have space after й).

So for example I have words красный, бархатный, койот, йодоформ, ковбойская

The first two words cannot be found and the view shows no result. But other words can be found. The position of й in search string does not matter. For example I can find ковбойская when I enter ковбой in search field. But if I enter красный I can't find this word, but красны shows me красный word.

Here is the SQL request formed by views

SELECT node.title AS node_title, node.nid AS nid, node.created AS node_created, 'node' AS field_data_body_node_entity_type
{node} node
WHERE (( (node.status = '1') AND (node.type IN  ('product')) AND (node.title LIKE '%красный%' ESCAPE '\\') ))
ORDER BY node_created DESC

So why it happens and how to avoid this bug?

  • I have zero knowledge on cyrillic, but looking at your question it did not make sense. Your question describes the й, but then the example words you give end with a u. When I hit edit and saw it in the editor, the word changed. Is there some combination of letters leading to a different display? Since it appears here as well, this might not be a Drupal specific problem?. Sep 28, 2017 at 21:35


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.