SQL Server not looking for text in Russian?

Question

SQL Server

I created a regular .mdf database with the following lines:

And the following content:

I'm trying to execute the following query on it:

SELECT product_name FROM Catalog WHERE product_type = 'Бытовая продукция'

But I get emptiness, returns nothing. The nvarchar type supports Unicode.
What's wrong?

Answer 1

SELECT product_name FROM Catalog WHERE product_type = N'Бытовая продукция'

The nvarchar type supports Unicode. What's wrong?

And you're not looking for Unicode.