Feb 14 2023 04:52 AM - edited Feb 14 2023 05:15 AM
Hello
I have a table with Polish characters, but I cant see the Polish characters. For example
Feb 14 2023 05:57 AM
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
Feb 14 2023 06:17 AM - edited Feb 14 2023 06:29 AM
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
Feb 14 2023 10:45 PM
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.
Feb 15 2023 01:06 AM
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