EF core MS SQL Case Sensitive what to set?

Question

C++ / C#

For the database set "Cyrillic_General_BIN2" Data type nvarchar(20)

select * from HOUSE_HOUSENUM
where Name ='33_а'

ID	Name
6076	33_А

How to compare by exact match? 33_аand 33_Aare different things.

Answer 1

Clarification of the question

SELECT * FROM HOUSE_HOUSENUM
  WHERE UPPER( Name ) = UPPER( '33_а' )

С COLLATE

SELECT * FROM HOUSE_HOUSENUM
  WHERE  Name = '33_а' COLLATE Cyrillic_General_CI_AI

To the question: why the default sorting options do not work ?
Answer: at some of the levels you redefined it. Documentation .