数字量输入el1722-BECKHOFF倍福倍福plc用什么语言
PARAMETER='NLS_CHARACTERSET'; VALUE ------------------------------------------ZHS16GBK SQL> COL VALUE NEW_VALUE NCHARSET SQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE
PARAMETER='NLS_NCHAR_CHARACTERSET'; VALUE ------------------------------------------ZHS16GBK 这里的语言字符集是有问题的,往下看操作就知道了:
-- INTERNAL_USE 是没有写在文档中的参数,用以强制完成字符集一致化 ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET; ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET; SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET; old new 1: ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET 1: ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK数字量输入el1722-BECKHOFF倍福倍福plc用什么语言
Data altered. SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET; old new 1: ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET 1: ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE ZHS16GBK
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE ZHS16GBK * ERROR at line 1: ORA-12714: invalid national character set specified -- 运行到此处出问题了,看来字符集不能是 ZHS16GBK 的了, -- 那为什么取的时候会取到呢?是因为早先的时候无知地使用了这个语句: SQL> UPDATE props SET value='ZHS16GBK' WHERE name='NLS_CHARACTERSET' or name='NLS_NCHAR_CHARACTERSET'; -- 其值原来是 AL16UTF16,UPDATE 后改成了 ZHS16GBK,现在把其改回去先; SQL> UPDATE props SET value='AL16UTF16' WHERE name='NLS_NCHAR_CHARACTERSET'; 2 1 row updated.
SQL> commit; Commit complete. -- 再次运行: SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET; old new 1: ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET 1: ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE ZHS16GBK
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE ZHS16GBK * ERROR at line 1: ORA-12714: invalid national character set specified -- 还是不行,看看错误原因: SQL> !oerr ORA 12714 12714, 00000, "invalid national character set specified" // *Cause: Only UTF8 and AL16UTF16 are allowed to be used as the national // character set
// *Action: Ensure that the specified national character set is valid -- 由此可知,Oracle 10g 的 NATIONAL CHARACTER SET 只有 2 个选择:AL16UTF16 与 UTF8 -- 下面直接用字符集名字,而不使用&NCHARSET 来取: SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16; Data altered. -- 修改数字量输入el1722-BECKHOFF倍福倍福plc用什么语言
-- 关闭数据库并重启: SQL> SHUTDOWN IMMEDIATE Data closed. Data dismounted. ORACLE instance shut down. SQL> STARTUP ORACLE instance started. Total System Global Area Fixed Size Variable Size Data Buffers Redo Buffers 612368384 bytes 2022696 bytes 251658968 bytes 352321536 bytes 6365184 bytes
-- 按照上面的步骤,一步一步来,一步不要少,完成以后,重新检索 col表。 CHARACTERSET TYPES_USED_IN
---------------------------------------- ------------ZHS16GBK AL16UTF16 ZHS16GBK AL16UTF16 ZHS16GBK AL16UTF16 CHAR NCLOB VARCHAR2 NVARCHAR2 CLOB NCHAR
已选择 6 行。 与之前的做一下对比: CHARACTERSET TYPES_USED_IN
---------------------------------------- ------------WE8ISO8859P1 WE8ISO8859P1 AL16UTF16 AL16UTF16 ZHS16GBK WE8ISO8859P1 AL16UTF16 已选择 7 行。 可看出: 对于 CHAR,VARCHAR2,CLOB 使用了 ZHS16GBK; 对于 NCHAR,NVARCHAR2,NCLOB 使用了 AL16UTF16; 再次使用 MyEclipse 打开看看,一切 OK 了. 相关内容: ======================================================================= ========= 环境变量可设置为: NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK' NLS_LANG='AMERICAN_AMERICA.ZHS16GBK' VARCHAR2 CHAR NCLOB NVARCHAR2 VARCHAR2 CLOB NCHAR
NLS_LANG='AMERICAN_AMERICA.US7ASCII' 改变 SESSION 会话的(客户端界面显示)语言: 错误写法: ALTER SESSION SET NLS_LANGUAGE='AMERICAN_AMERICA.ZHS16GBK'; SET NLS_LANG='AMERICAN_AMERICA.ZHS16GBK' 正确写法: ALTER SESSION SET NLS_LANGUAGE=AMERICAN; ALTER SESSION SET数字量输入el1722-BECKHOFF倍福倍福plc用什么语言 NLS_LANGUAGE='SIMPLIFIED CHINESE'; 有空格使用''括起来. 有关数据库字符集: 1. 查看数据库字符集 数据库服务器字符集: SELECT * FROM NLS_DATABASE_PARAMETERS; 其来源于 props,是表示数据库的字符集;数字量输入el1722-BECKHOFF倍福倍福plc用什么语言
