Forum Discussion

soldier_rong's avatar
soldier_rong
Helper II
3 years ago
Solved

Connecting to Oracle database with Chinese garbled code

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:  
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi soldier_rong 

     

    Sorry for the delay. Please try this again. 

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

     

    Best regards,

    Jing

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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's avatar
soldier_rong
Helper II
3 years ago

Hi v-jingzhang ,

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

    • soldier_rong's avatar
      soldier_rong
      Helper II
      3 years ago

      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's avatar
        v-jingzhang
        Community Support
        3 years ago

        Hi soldier_rong 

         

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

         

        Jing