Query Polish data in Sql

[MGeorgeAlexander]

Hello

I have a table with Polish characters, but I cant see the Polish characters. For example 

 Select  'Zakład Mechaniczny' 

The above query results as below 

(No column name)
Zaklad Mechaniczny

Can you please help, how can i view the Latin 2(Polish characters?)

[#2]

Can you please help, how can i view the Latin 2(Polish characters?)

---

And that's the problem, several polish characters don't exists in Latin2 ASCII character set.

Best bet is to use Unicode = NVarchar data type, example:

Select  N'Zakład Mechaniczny' -- Unicode

[#3]

Thank you.

If I have the polish characters in the Table column and the column Data type is Nvarchar(I altered it, but I am unable to see it.

Read about Collate, But unsuccessful in using to view the table columns data in Polish

[#4]

---

the column Data type is Nvarchar(I altered it, but I am unable to see it

---

@MGeorgeAlexander , altered it from varchar = ASCII to nvarchar = Unicode? Then the informations/right characters are already lost.

[#5]

I did create a new table with the column as Nvarchar and inserted the polish data and query (as in my screenshot), and Select Query is not bringing the expected results

@olafhelper