Solve the Problem of garbled display in Toad for Oracle

1. Check the database character set:

Use the following statement: Select userenv ('language ') from dual; or: Select name, value $ from props $; to view.

After viewing: the character set of the database is displayed in the columns that appear.

The result is as follows:

USERENV ('language ')

-----------------------------------

AMERICAN_AMERICA.ZHS16GBK <---- This is the character set encoding of your database.

2. Next, find the environment variable on your computer (my computer-properties-advanced-environment variable) and add the system variable to your computer:

Under system variables (new)

Variable name: NLS_LANG

Variable value: AMERICAN_AMERICA.ZHS16GBK

The variable value is based on the character encoding value that you just found from the database.

After adding the system variables, save the system variables you have set.

3. Restart the Toad forOracle client.