:::: MENU ::::
Posts tagged with: sql-server

Cyrillic characters replaced by question mark in stored procedure

I have an issue with Cyrillic characters. In my create procedure script, there is

select
    ...
    case 
        when aug.IsGroup = 0 then N'Нет' 
        else N'Да' 
    end as IsGroupFact
    ...

There are all variables which related to Cyrillic characters contains in nvarchar(max).

After adding .sql file of stored procedure into the project and pushing it to the main CI/CD branch, the characters becomes to the

select
    ...
    case 
        when aug.IsGroup = 0 
            then N'???' 
            else N'??' 
    end as IsGroupFact
    ...

What should I do?