Connecting to Oracle database with Chinese garbled code

[soldier_rong]

Dear~~

The Chinese of the data we check in PLSQL is normal, but the Chinese on Power Query is garbled. Thanks for any ideas.

PLSQL:

Power Query:

[v-jingzhang]

Hi @soldier_rong 

Try adding a custom column with the following code. Change [Column Name] accordingly. This will convert a text column from Windows encoding to UTF8. Chinese characters usually require encoding UTF8. 

Text.FromBinary(Text.ToBinary([Column Name], TextEncoding.Windows), TextEncoding.Utf8)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[soldier_rong]

Hi @v-jingzhang ,

Hope you well.

Any idea would be appreciated~~

[v-jingzhang]

Hi @soldier_rong 

I learnt from another thread of yours that your Oracle DB is using WE8ISO8859P1. WE8ISO8859P1 is ISO8859 Part 1, it is a Western European character set, based on the ISO standard; it is also known as Latin-1. Choosing a Character Set (oracle.com)

Perhaps you can use SQL statements to query data from the Oracle database and convert the column from ISO-8859-1 to Utf-8. There are some relevant solutions in the following link, but it doesn't have an example for Oracle, hope it would be helpful: Convert Text Value in SQL Server from Utf8 to Iso 8859-1 - ITCodar

Best regards,

Jing

[soldier_rong]

Hi @v-jingzhang ,

still not worked....Any idea would be appreciated.

[v-jingzhang]

Hi @soldier_rong 

Sorry I don't have other ideas sadly. Do you have a Power BI Pro license? If you have, you can create a support ticket at Support | Microsoft Power BI without additional charge. Escalation engineers will contact you soon and they can support you in some other ways. How to create a support ticket in Power BI

Best regards,

Jing

[soldier_rong]

Hi @v-jingzhang ,

Noted with thanks. We have the Pro license but not under my account. so can I create a support ticket like this myself? Or do I have to ask the Pro user to make a case like this?

Thanks again.

[v-jingzhang]

Hi @soldier_rong 

You need to ask the Pro user to help create the support ticket.

Jing

[v-jingzhang · Accepted solution]

Hi @soldier_rong 

Sorry for the delay. Please try this again. 

Text.FromBinary(Text.ToBinary([Column Name], TextEncoding.Ascii), TextEncoding.Utf8)

Best regards,

Jing

[soldier_rong]

Hi @v-jingzhang ,

Thanks again. I tried it, but still not worked.....

I'm not sure if I want to go up to the database level to modify this code set WE8ISO8859P1, but this has a big impact on our production. So any suggestions or ways to fix the messy codes?

Thanks in advance.

BR,

Soldier

[soldier_rong]

Hi @v-jingzhang 

Hope you are well.

I try but not worked and still garbled code(please see the pic 1).

I also try below code and the result is not good as pic 2..