MYSQL responds differently to similar queries

Question

I am using xamp server:

when i run select query to get data like

SELECT `id`, `relation`, `member_id`, `Relative_id` 
    FROM `relationship` WHERE `relation` = 'माँ'

Everything works perfectly

But when running below example queries, I get 0 results.

Example 1:

SELECT `id`, `relation`, `member_id`, `Relative_id` 
    FROM `relationship` WHERE `relation` = 'बेटी'

Example 2:

SELECT `id`, `relation`, `member_id`, `Relative_id` 
    FROM `relationship` WHERE `relation` = 'पिता'

image referring to db table

+3

AJAY RAGHUVANSHI June 27. 17 at 17:03

2 answers

tony gil · Answer 1 · 2017-06-27T18:20:08+0000

You have to use the Unicode character set (utf8_unicode_ci works great), declare the field as VARCHAR

and use LIKE

instead=

SELECT `id`, `relation`, `member_id`, `Relative_id` 
FROM `relationship` WHERE `relation` LIKE 'पिता';

Tested and working.

Ravi · Answer 2 · 2017-06-27T17:17:45+0000

To compare a language, you need to use an encoding UTF-8

.