Oracle query garbled solution: 1. Check the server-side encoding; 2. Execute the statement "select * from V$NLS_PARAMETERS"; 3. Set the environment variable.
The operating environment of this article: Windows 7 system, Dell G3 computer, Oracle 11g version.
How to solve the oracle query garbled problem?
Oracle query Chinese garbled characters
is caused by the inconsistency between the encoding used by the PLSQL client and the server-side encoding.
1. Check the server-side encoding
Select userenv('language') from dual;
The actual result I found is: AMERICAN_AMERICA.UTF8 (everyone may find it differently)
2. Execute the statement select * from V$NLS_PARAMETERS
Check whether the VALUE item corresponding to NLS_LANGUAGE in the PARAMETER item in the first row is the same as the value obtained in the first step.
If not, environment variables need to be set.
3. Set environment variables
Computer-->Properties--> Advanced system settings--> Environment variables-->System environment variables-->New
Set variable name: NLS_LANG
Variable value: The value found in the first step, AMERICAN_AMERICA.UTF8 (subject to the one you found in the first step)
Related recommendations: oracle database learning tutorial
The above is the detailed content of How to solve the problem of garbled characters in Oracle query. For more information, please follow other related articles on the PHP Chinese website!