Unicode predicate with like clause ( N'%өө%' )returns all rows

Viewed 113

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'%өө%'
1 Answers
Related