Oracle garbled problem

The Oracle garbled problem is generally caused by inconsistent Oracle character set settings and operating system character set settings, which have to mention two operating system environment variables, LANG and Nls_lang

Lang is a set of languages, regions, and character sets for Linux systems that are valid for applications under Linux, such as Date

Nls_lang is a setting for Oracle language, region, and character set that works with tools in Oracle

Obviously, you need to modify the nls_lang environment variable

View the Oracle character set in the following way:

1. Enter Sqlplus

Command:sqlplus/nolog

2. Connect to the database as a system administrator

Command:conn/as sysdba

3. Enter Query statements

Command:select * from v$nls_parameters where parameter = ' nls_characterset ';

Query results such as:

View Nls_langlang variable values

Command:echo $NLS _langlang

garbled because this Oracle and operating system code is not the same result

Therefore, you can set the value of the Nls_langlang variable to resolve

Command:export nls_lang= "American_america. Al32utf8 "