Forum Discussion

MGeorgeAlexander's avatar
MGeorgeAlexander
Copper Contributor
Feb 14, 2023

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...
olafhelper's avatar
olafhelper
Bronze Contributor
Feb 14, 2023
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
  • MGeorgeAlexander's avatar
    MGeorgeAlexander
    Copper Contributor
    Feb 14, 2023

    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's avatar
      olafhelper
      Bronze Contributor
      Feb 15, 2023

       

      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.

      • MGeorgeAlexander's avatar
        MGeorgeAlexander
        Copper Contributor
        Feb 15, 2023

        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 

Resources