Query fails with Russian letters

Question

This query:

SELECT pair_ID FROM quotes_search WHERE  pair_type="type_one"
    AND ( symbol LIKE 'лукойл%' OR  UPPER(pair_name) LIKE UPPER('лукойл%') );

fails with Russian characters (English characters works fine). Any ideas? table and field are utf8_general_ci

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
One more thing, This query is successful when using mysql version:5.1.61
But failes when mysql version: 5.1.70

Slightly OT, but I suppose you are doing comparison with a nonbinary string, so case sensitivity does not matter and there is no need to use `UPPER` http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html — DrCopyPaste, Oct 15 '13 at 13:08
Maybe this can help you? http://stackoverflow.com/a/7780070/2186023 — DrCopyPaste, Oct 15 '13 at 13:09
Are you sure it's the russian characters and not the double quotes around type_one? — Dan Bracuk, Oct 15 '13 at 13:12
Would adding an `N` or `_utf8` work? ie, `N'лукойл%'` or `_utf8'лукойл%'` It should specify that the string is an `nchar`: http://dev.mysql.com/doc/refman/5.0/en/charset-national.html — valverij, Oct 15 '13 at 13:12
@AsafMaoz yes that was OT = off topic just a suggestion for more efficient query ;) — DrCopyPaste, Oct 15 '13 at 13:13
From what I can tell it has something to do with the russian chars, if the string is: 'abc' it works fine. — Asaf Maoz, Oct 15 '13 at 13:28

score 1 · Answer 1 · answered Oct 15 '13 at 13:28

1

Run this queries after connecting db

SET character_set_client = "utf8";
SET character_set_results = "utf8";
SET character_set_connection = "utf8";

answered Oct 15 '13 at 13:28

mugiseyebrows

4,138
1
14
15

score 0 · Answer 2 · answered Oct 15 '13 at 13:13

0

Try this

... symbol LIKE CONCAT(_utf8 x'лукойл%', '%') OR ...

answered Oct 15 '13 at 13:13

Artur Udod

4,465
1
29
58

Query fails with Russian letters

2 Answers2