Forum Discussion

mdelasheras's avatar
mdelasheras
Helper I
8 years ago

Encoding SQL Server

Hi! I have some specials characters being displayed incorrectly when reading from SQL server. This may happen because of the Encoding so I would like to change it. Can i add a parameter in my conn...
Need Help
mdelasheras's avatar
mdelasheras
Helper I
8 years ago

What should I do to correct the character encoding? There is no way to display the right codification?

It's a bit annoying to show some tables with strange symbols

mdelasheras's avatar
mdelasheras
Helper I
8 years ago

Hi!


I have some specials characters being displayed incorrectly when reading from SQL server. This may happen because of the Encoding so I would like to change it. Can i add a parameter in my connection query?

I tried like this but just getting some errors:

 

let
Origen = Sql.Database("serverIP", "database",Encoding="1252"),
 Origen{[Schema="schema",Item="item", Charset="1252"]}[Data],

Thanks in advance!