Forum Discussion
MGeorgeAlexander
Feb 14, 2023Copper Contributor
Query Polish data in Sql
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) Zak...
MGeorgeAlexander
Feb 14, 2023Copper Contributor
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
olafhelper
Feb 15, 2023Bronze Contributor
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.
- MGeorgeAlexanderFeb 15, 2023Copper Contributor
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