When I use following condition in SQL Query
[FieldName] like N'%өө%'
here the field name can be replaced with any column in any table you have..collation is SQL_Latin1_General_CP1_CI_AS
I tested on SQLServer express,SQLServer 2012,2016 for any type of field.
Any ideas on why this is happening ?
Can anybody please confirm if it is same for you?
below is a simple repro:
create table dbo.test111
(
id int
)
insert into dbo.test111
select ROW_NUMBER() over (order by (Select null))
from
sys.objects s
cross join
sys.objects s1
select * from dbo.test111 where id like
N'%өө%'