Forum Discussion

fafa's avatar
fafa
Copper Contributor
Dec 12, 2024

Microsoft query help

when i using Microsoft Query on my computer, as it cannot display Chinese characters properly and shows garbled text.(version: 2016)

 

This is a normal case example I used at school

 

 

excel
office 365
  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Dec 16, 2024

    It may related to Unicode most of the time:

     

    1. Check Regional and Language Settings:
      • Ensure that your system's regional and language settings are configured to support Chinese characters. Go to Control Panel > Clock, Language, and Region > Region and Language, and make sure the formats and system locale are set to Chinese.
    2. Change the Data Source Encoding:
      • When setting up your data source in Microsoft Query, make sure to select the correct encoding. If you're using an ODBC connection, you might need to configure the ODBC driver to use UTF-8 or another appropriate encoding.
    3. Update Microsoft Office:
      • Ensure that your Microsoft Office 2016 is fully updated. Sometimes, updates can fix bugs related to character encoding.
    4. Use a Different Query Tool:
      • If the issue persists, consider using a different tool that better supports Unicode, such as Power Query in Excel, which is more modern and robust.
    5. Check the Source Data:
      • Verify that the source data itself is correctly encoded. If the data source (e.g., a database or a CSV file) is not using the correct encoding, it can cause issues when queried.

Resources