All of Oracle's garbled solutions

All of Oracle's garbled solutions

is not often see a variety of garbled, see the head on the big, we do not fear, all the problems will have one or more than one solution, there is a famous saying good: million law is not away from its trace. Online most of the tool garbled and code operation garbled confuse, the scheme see a lot of is a paste one, not a little innovation, so today out of this blog.

The following scenario service-side Character set encoding is: Simplified Chinese_china. Us7ascii Test OK, other codes can be referenced

A. Tool garbled:

Use Plsql developer to query or edit the time to appear?? The time:

Cause: The character set on the client machine and the server is inconsistent

Solve:

First query the service side of the character set encoding, and then the client's modification has been;

1. Query the character set of the service:

2. Use the tool to view the client's character set encoding:

Open tool: Help-support info

3. Set Environment variables (System environment variables):

Nls_lang=simplified Chinese_china. US7ASCII ( set encoding must be consistent with the server)

If not, it is recommended to restart your computer!

Two. Query garbled:

Set of two:

1. Modify the Environment variables:

Nls_lang=simplified Chinese_china. US7ASCII ( set encoding must be consistent with the server)

2. Modify the registry: (for the sake of insurance, look for all the Nls_lang in the registry to avoid having multiple)

hkey_local_machine\software\oracle\key_oradb11g_home1

If not, it is recommended to restart your computer!

Three. Inserting garbled characters:

Settle in ...

Four. Import or export garbled:

Not currently

All of Oracle's garbled solutions