[Oracle] solves the problem of Oracle's garbled language in CentOS 7

First in the formation of Chinese garbled reason is due to the character set is not unified, different character sets in the process of conversion will inevitably appear garbled, of course, do not exclude can be converted. So to solve the problem of Chinese garbled, the idea is that the input, storage, display and other processes involved in the character set are unified as one, for Oracle must first meet the prerequisite is to serve and customer segment of the character set unity, if not solve the problem, but also to the system's character set and its unity, Even the character set used for importing or entering data is uniform.

After looking at some information on the internet, it is said that modifying the server character set risk is relatively large, indeed, test development with good said, if it is on-line Project Server, then modify the server character set brings the consequences is unbearable, nonsense I said the following paste on my solution.

1, garbled problem

At the beginning of the SQL statement to build a table, and insert data, the final Select, the command interface always displays the following questions:

650) this.width=650; "src=" Http://images.cnitblog.com/blog/605905/201412/242204196555769.png "/>

2, query the character set of the service side

Sql> Select Userenv (' language ') from dual;

The following results are displayed:

American_america. we8mswin1252

This character set is more wonderful, never seen, but have not seen too many things, since people design default so the character set, should have its advantages

3. View the character set of the client settings in the configuration file

Vi/home/oracle/.bash_profile

The results appear as follows:

Export Nls_lang=american_america. Zhs16gbk

I originally set the client's charset to American_america when I installed Oracle. ZHS16GBK, the character set of the server and client must be wrong, and the character set of the client will be modified to American_america. we8mswin1252, re-executing the program, the pleasing result appeared:

650) this.width=650; "src=" Http://images.cnitblog.com/blog/605905/201412/242211534684660.png "/>

[Oracle] solves the problem of Oracle's garbled language in CentOS 7