The following summarizes a large number of solutions to Oracle Chinese garbled characters. If you encounter such problems, refer to them.
The following summarizes a large number of solutions to Oracle Chinese garbled characters. If you encounter
Method 1: sqlplus "User/password as sysdba" sqlplus "sys/sys as sysdba"Method 2: sqlplus/nolog
SQL> conn/as sysdbaSQL> shutdown immediate;SQL> startup mountSQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES =
Let's talk about the problem. When a 64-bit oracle is installed on a 64-bit operating system, the default encoding is SIMPLIFIED CHINESE_CHINA.ZHS16GBK, but this encoding is not available during actual installation. After installation, the data in
Environment:OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 Generally, the character set is selected during installation. to modify the character set of the database, we recommend that you recreate the database (EXP/EXPDP export before importing ),
Problem description: Oracle installed in Linux by a colleague, the default character set is not modified. WE8ISO8859P1 is used and Chinese characters are not supported,
The problem is that the Chinese data entered by the client can be displayed.
Error 1: ORA-01756: quotedstringnotproperlyterminated character set encoding inconsistent Chinese content cannot be inserted query character encoding settings for the current database: SQLselect * fromv $
Oracle modify character set view oracle server code: select * from sys. nls_database_parameters; check the client code: select * from sys. nls_session_parameters; modify the client encoding: open the runner and go to the Registry to edit and run --
ArcSDE data migration Exception from HRESULT: 0x800000038 Problem and Solution, arcsde0x800000038
I. Problem Description
1. The interface ESRI is used to create database tables (data migration) in batches in the ArcSDE (Data Server) using the gdb
Today, the ORA-01756: quoted string not properly terminated error occurred while importing data using volume El. Now I 've sorted out some solutions that are commonly used in oracle.
Error 1: ORA-01756: quoted string not properly terminated
Chinese
What is the Oracle character set?
The Oracle character set is a collection of symbols for interpretation of byte data. It has different sizes and an inclusive relationship.
Oracle supports the national language architecture, allowing you to store,
One, what is the Oracle character Set
An Oracle character set is a collection of symbols that are interpreted as a byte of data, having a size and a mutual containment relationship. ORACLE's support for the national language architecture allows you
American_america. WE8ISO8859P1, this character encoding is a Western European character encoding, corresponding to the. NET is iso-8859-1 character encoding, so only need to change to the system's default character encoding on the line.
Workaround:
Error 1:ora-01756:quoted string not properly terminated
Chinese content cannot be inserted due to inconsistent character set encodingQuery the character encoding settings for the current database:Sql> SELECT * from V$nls_parameters T WHERE
CMD command startsSqlplus/nolog--Visit sqlplusConnect/as SYSDBA--dba Identity LoginSHUTDOWN IMMEDIATE; --Close the databaseSELECT * from V$nls_parameters; --View the database character setORA-12899 error value too large for columnCode to copy code
Oracle Import failed, the length of the ORA-12899, is the character set caused by the Chinese in the UTF-8 accounted for 3 bytes, zhs16gbk accounted for 2 bytes, and the source DMP file character set is ZHS16GBK the data poured out of the
Ext.: http://www.cnblogs.com/jay-xu33/p/5210098.htmloracle11g modifying the character set to ZHS16GBK1.cmd, CD to the server side of Oracle database software such as: D:\app\Administrator\product\11.2.0\dbhome_1\BIN2. Enter set oracle_sid= the SID
Method One: Sqlplus "user/password as SYSDBA" Sqlplus "Sys/sys as SYSDBA"Method Two: Sqlplus/nologSql> Conn/as SYSDBAsql> shutdown immediate;Sql> Startup Mountsql> ALTER SYSTEM ENABLE RESTRICTED SESSION;sql> ALTER SYSTEM SET
The newly installed database may need to adjust the Oracle database encoding, otherwise importing data may be an error.oracle11g changing the character set Al32utf8 to ZHS16GBKSQL codeDatabase Character Set (Al32utf8) and Client character set
I. What is the Oracle character setThe Oracle character set is a collection of symbols that interpret a byte of data, have a size, and have a mutual containment relationship. ORACLE's support for national language architectures allows you to store,
in the process of using Oracle, there are all sorts of problems, all sorts of bugs, and ORA-12899 is the problem I've been having when I imported data into my local machine. But fortunately has solved this problem, now share, the solution;
appears
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.