character issue

[nranito]

I create a query with odbc "select ação from dual" and the result is "ac~o". Some characters come all mixed up.

There is some parametrization to solve this issue?

[Eric_Zhang]

---

@nranito wrote:

I create a query with odbc "select ação from dual" and the result is "ac~o". Some characters come all mixed up.

There is some parametrization to solve this issue?

---

@nranito

Did you connect that odbc from Power BI Desktop? It appears some encoding issue.

[nranito]

yES, Connection is by odbc.

How to fix that encoding issue?

[nranito]

Depends on any (regional) settings, something??

[nranito]

Update:

(Oracle database)

Columns defined as VARCHAR2 CHAR show up fine; columns defined as VARCHAR2 BYTE come all messed