pgAdmin 4 v2工具栏显示乱码（国际化异常）求助

Hey there, sorry to hear you're stuck with garbled toolbar and interface text in pgAdmin 4 v2—this is a common encoding-related glitch with older pgAdmin builds on Windows, and we can work through some fixes to get it sorted.

Here are several solutions to try, ordered from easiest to more targeted:

1. Adjust System Regional Settings #

Older pgAdmin versions often depend on Windows' system locale settings for non-Unicode programs. Let's tweak that:

• Open Control Panel → Region → Switch to the Administrative tab
• Click Change system locale
• If the "Beta: Use Unicode UTF-8 for worldwide language support" option is checked, uncheck it, hit OK, and restart your PC. If it's unchecked, enable it instead, then restart.
• After rebooting, launch pgAdmin 4 again to see if the text displays correctly.

2. Reset pgAdmin 4 Configuration Files #

Corrupted config files can cause rendering weirdness. Let's reset them:

• First, close pgAdmin 4 completely.
• Navigate to C:\Users\[Your Username]\AppData\Roaming\pgAdmin (replace [Your Username] with your actual Windows username).
• Backup the pgadmin4.db and config.py files (copy them to another folder just in case).
• Delete these two files from the pgAdmin directory.
• Launch pgAdmin 4 again—it will generate fresh configuration files automatically. Check if the garbled text issue is gone.

3. Force UTF-8 Encoding in Python #

Since you're using Python 2.7 (which has different encoding defaults than Python 3), we can explicitly set UTF-8 for pgAdmin:

• Locate the main pgAdmin 4 startup script, usually named pgAdmin4.py in your installation directory (e.g., C:\Program Files\pgAdmin 4\v2\web).
• Open the file with a text editor like Notepad++.
• Add these lines at the very top of the script, before any other code:

  import sys
  reload(sys)
  sys.setdefaultencoding('utf-8')
  

• Save the file and restart pgAdmin 4. This forces the Python environment to use UTF-8 encoding, which often fixes text rendering problems.

4. Verify System Fonts #

Missing or corrupted system fonts can also lead to garbled text:

• Open Control Panel → Fonts and check if common sans-serif fonts like Segoe UI or Arial are installed.
• If they're missing, install them (you can copy them from another working Windows 10 device or download official font packages).
• Restart your PC and launch pgAdmin 4 to test the interface.

内容的提问来源于stack exchange，提问作者Joe