experience garbled oracle solution
First: First of all, to be sure you want to import the dmp file is the file with garbage characters (I garbled the reason for this is that because the company's database development environment al_attr the data in the table already are garbled, and the most horrible Every time the time import of data to test this form, as well as a few days later to find further information on how to solve the problem have not been garbled implementation);
Second: In the operation of the database before the export dmp file about the best implementation of select * from nls_database_parameters, the source character set dmp file to the record for the data in question into the database garbled when compared to see whether the character set the same
Introduce the following the following oracle and the corresponding character set to view and modify the Ways: the database server character set select * from nls_database_parameters, from props $ express its database file corresponding character set settings, can UPDATE PROPS $ SET value $ = 'ZHS16CGB231280' WHERE NAME = 'NLS_CHARACTERSET' to modify the parameters
Client character set environment select * from nls_instance_parameters, derived from v $ parameter, said client-side character set settings are possible parameter files, environment variables or registry
Conversation environment character set select * from nls_session_parameters, derived from v $ nls_parameters, that set up their own conversation, the conversation may be environment variables or alter session are completed,
If no special session of the settings, in line with nls_instance_parameters. Character set client requirements in line with the server in order to show the right of non-Ascii characters in the database. If there is a time when a number of settings, alter session> Environment Variables> registry> parameter document character set a uniform requirement, but the language settings can be different from the proposed language setting English. Character sets such as are zhs6gbk, while nls_lang can be American_America.zhs6gbk.
Here are some possible corresponding client NLS_LANG character set (by modifying the registry can be modified)
AMERICAN_AMERICA.US7ASCII AMERICAN_AMERICA.WE8MSWIN1252 AMERICAN_AMERICA.ZHS16GBK AMERICAN_AMERICA.AL32UTF8 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Related Posts of experience garbled oracle solution
-
Log in using IE em Linux server solution appears garbled
Source: Net sea cockle-pickers Problem description In the Linux (Unix) environment successfully installed Oracle 10g, the next from the windows registry with IE browser, 10g of em, the button is the "word of mouth," so the box. Solution In ...
-
Windows garbled on the sqlplus
Solution: cmd where implementation of the set nls_lang = american_america.zhs16gbk
-
Oracle em button appears garbled practical solutions
Oracle EM buttons appear garbled in the actual application is often in the actual operation to bring a lot of inconvenience, the following article that describes Oracle em button appears garbled practical solutions, the following is the detailed desc ...
-
LINUX + ORACLE10 - EM button, garbled, how to solve the
LINUX + ORACLE10 - EM button, garbled, how to solve the In the linux environment, install oracle10, enable EM when the button appears garbled phenomenon, as follows: The Internet to find a find a cause, the original is because the installation oracle ...
-
oracle em in the garbage solution button
One, oracle em in the button garbled solution: rn 1. Modify the jdk following fonts. [oracle @ rac2 db_1] $ cd $ ORACLE_HOME / jdk / jre / lib / [oracle @ rac2 lib] $ mv font.properties font.properties_bak [oracle @ rac2 lib] $ cp font.properties.zh_ ...
-
Under the settlement rhel5.3 oracle10gEM garbled
Under the oracle to solve redhat5.3 10g EM garbage problem redhat 5.3ORACLE 10G, in the open EM Console, all the buttons garbled problems, solutions are as follows: 1) were backed up ORACLE own JRE and JDK under the current font configuration file (f ...
-
linux install oracle9i Chinese garbled Solutions
rnrnrnrnrnrnrnrnrnrn linux install oracle9i Chinese garbled Solutions rnrnrnrn rn rn rn Oracle on Linux, installed when the characters are the "mouth" shape garbled the first time is rather tense in English can only be installed and after r ...
-
ORACLE garbled solution to the problem
Oracle database using sqlplus to connect when always occur???? A class of characters, Mainly because the server and the client language settings are different. Japanese environment on the server side is set to JA16SJIS, client does not have to set up the
-
oracle em web button garbled
Oracle 10g provides a Web-based management tool for EM (Enterprise Manager). Today, some linux machine to use a small error, the buttons are all garbled, the system Linux AS4. After some search, online information on proposed changes in many reproduc ...
-
Database garbled cause and solution
"In the insert inserted using SQL * Plus are Chinese, why a deposit server, and then select out of that???" rn "Sometimes, the server data pilot out, reinstall the server, then import the data, results, place into a data query???" rn .
Leave a Reply