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)
Zaklad Mechaniczny
 
Can you please help, how can i view the Latin 2(Polish characters?)
  • 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.

Resources