All of Oracle's garbled solutions

Source: Internet
Author: User

Tags: fan lin set back War tran adb plsql form

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: