Shulou(Shulou.com)06/03 Report--

1. First query the database character set

SQL > select userenv ('language') from dual; USERENV (' LANGUAGE')-AMERICAN_AMERICA.AL32UTF8 SQL > exit

From above, we know that the database character set is AMERICAN_AMERICA.AL32UTF8.

two。 Configure environment variables

Set the boot restart to automatically load it to the

/ home/oracle/.bash_profile

Or / etc/profile

Echo 'export NLS_LANG= "AMERICAN_AMERICA.UTF8" > > / etc/profilesource / etc/profile

3. If you query again, you can recognize Chinese normally.

Cause analysis:

Sqlplus garbled is related to the NLS_LANG variable of the operating system. Garbled code occurs when the database character set is inconsistent with the NLS_LANG variable.

These are the details of how to do linux sqlplus garbled, please pay more attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.