topic Re: character issue in Developer

character issue

nranito — Wed, 29 Nov 2017 16:43:13 GMT

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?

Re: character issue

nranito — Wed, 29 Nov 2017 16:49:38 GMT

Depends on any (regional) settings, something??

Re: character issue

nranito — Wed, 29 Nov 2017 18:49:33 GMT

Update:

(Oracle database)

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

Re: character issue

Eric_Zhang — Fri, 01 Dec 2017 09:17:29 GMT

@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.

Re: character issue

nranito — Thu, 18 Jan 2018 17:09:57 GMT

yES, Connection is by odbc.

How to fix that encoding issue?