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

10 Replies

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

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

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

       

       

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        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