0
SELECT *
FROM TABLE
WHERE column_name LIKE N'%Ө%'

When I use this query, it returns all rows of the table.

It works like : 

SELECT *
FROM TABLE
WHERE column_name LIKE '%%'

I also tried : 

SELECT *
FROM TABLE
WHERE column_name LIKE N'%ӨTӨEӨSӨTӨ%'

and it works like : 

SELECT *
FROM TABLE
WHERE column_name LIKE '%TEST%'
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
xArtViel
  • 1
  • 1

1 Answers1

0

use collation Cyrillic_General_100_CI_AS, like this:

SELECT *
FROM TABLE
WHERE column_name LIKE N'%Ө%' COLLATE Cyrillic_General_100_CI_AS
OR column_name LIKE N'%ӨTӨEӨSӨTӨ%' COLLATE Cyrillic_General_100_CI_AS
Lkhagva-Ochir Buuruu
  • 1
  • 1