How to return georgian string in SQL Server

Question

I have a query below:

case 
   when 1 = (select Loc_ID from tbl_Web_User where Phone = '123456789') 
      then 'Reached Quota' 
      else 'მიღწეული კვოტა' 
end

When I returned georgian characters, it returns ?????????? like this. How can I show georgian string correctly?

`SELECT * FROM YourTable WHERE YEAR(DateEntered) BETWEEN 1714 AND 1830` — Martin Smith, Sep 09 '17 at 15:57
You wanted a [Georgian](https://en.m.wikipedia.org/wiki/Georgian_era) string? — Martin Smith, Sep 10 '17 at 10:36

score 1 · Accepted Answer · answered Sep 09 '17 at 09:27

1

You need to make sure to specify that you need Unicode string literals - you do that by prefixing the string with a N - like this:

case 
   when 1 = (select Loc_ID from tbl_Web_User where Phone = '123456789') 
      then N'Reached Quota' 
      else N'მიღწეული კვოტა' 
end

answered Sep 09 '17 at 09:27

marc_s

1

This is what i want thank you @marc_s it work for me – saulyasar Sep 09 '17 at 09:28

1 Answers1