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 

 

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