Home>Article>Operation and Maintenance> What to do if linux sqlplus is garbled
What should I do if linux sqlplus is garbled? SQLPlus Chinese garbled processing under Linux
1. First query the database character set
SQL> select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.AL32UTF8 SQL> exit
It is known from the above that the database character set is AMERICAN_AMERICA.AL32UTF8
2. Configure the environment Variable
Set to automatically load after booting and restart and put it in
/home/oracle/.bash_profile
or /etc/profile
echo 'export NLS_LANG="AMERICAN_AMERICA.UTF8"'>>/etc/profile source /etc/profile
3. Query again to recognize Chinese
Cause analysis:
sqlplus garbled characters are related to the NLS_LANG variable of the operating system. When the database character set is inconsistent with the NLS_LANG variable, garbled characters will be generated.
Recommended study: "linux tutorial"
The above is the detailed content of What to do if linux sqlplus is garbled. For more information, please follow other related articles on the PHP Chinese website!