SQL cannot select rows with special characters

Question

I am trying to run a query that goes like this:

SELECT TOP (1000) [name] 
FROM [mpnew].[dbo].[arts] 
WHERE [grupa] = 'NAMJEŠTAJ'

SQL returns 0 rows even though i only have 1 row in my whole table and that row has a [grupa] = 'NAMJEŠTAJ'

Answer 1

Unicode literal strings need to be prefixed with N:

SELECT TOP (1000) [name] 
FROM [mpnew].[dbo].[arts] 
WHERE [grupa] = N'NAMJEŠTAJ'
                ^