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 

 

Sorry for the delay. Please try this again. 

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

 

Best regards,

Jing

  • soldier_rong's avatar
    soldier_rong
    Helper II
    3 years ago

    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