更新时间:2024-10-01 23:00:00 nls_nchar_characterset表示数据库默认字符集,用于 NCHAR、NVARCHAR2、NCLOB 等数据类型。 说明 该变量不支持修改。 属性描述 参数类型varchar 默认值AL16UTF16 取值范围N/A 生效范围Global 是否参与序列化是 是否影响计划生成是 联系我们 AI助手...
nls_nchar_characterset表示数据库默认字符集,用于 NCHAR、NVARCHAR2、NCLOB 等数据类型。 说明 该变量不支持修改。 属性描述 参数类型varchar 默认值AL16UTF16 取值范围N/A 生效范围Global 是否参与序列化是 是否影响计划生成是 鼠标选中内容,快速反馈问题
若直接运行 ALTER DATABASE NATIONAL CHARACTER SET AL16UTF16; 也可以,但是可能会出现‘ORA-12717: Cannot ALTER DATABASE NATIONAL CHARACTER SET when NCLOB data exists’ 这样的提示信息 报错信息如下: Wed May 30 16:25:58 2012 alter database national character set AL16UTF16 Wed May 30 16:25:58 2...
NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION10.2.0.4.0 主要需要关心的就是 NLS_NCHAR_CHARACTERSET 和 NLS_CHARACTERSET。 NLS_CHARACTERSET 是CHAR, VARCHAR2, CLOB 等列的编码。 NLS_NCHAR_CHARACTERSET 是NCHAR, NVARCHAR2, NCLOB等列的编码。
SQL>update props$ set value$='ZHS16GBK' where name='NLS_CHARACTERSET'; SQL>update props$ set value$='AL16UTF16' where name='NLS_NCHAR_CHARACTERSET'; 4、如果还没有数据,最好的办法还是用dbca重新创建instance 5、 确认字符集是否修改
From 9i onwards the NLS_NCHAR_CHARACTERSET can have only 2 values: UTF8 or AL16UTF16 who are Unicode charactersets. 3、ORACLE中有两大类字符型数据,VARCHAR2是按照数据库字符集来存储数据。而NVARCHAR2是按照国家字符集存储数据的。同样,CHAR和NCHAR也一样,一是数据库字符符,一是国家字符集。
The NLS_CHARACTERSET is used for CHAR, VARCHAR2, LONG and CLOB columns; The NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2 and NCLOB columns. From 9i onwards the NLS_NCHAR_CHARACTERSET can have only 2 values: UTF8 or AL16UTF16 who are Unicode charactersets...
12) Can i use AL16UTF16 as NLS_CHARACTERSET ?13) I'm inserting <special character> in a Nchar or Nvarchar2 col but it comes back as ?, � or without accents when selected.14) Do i need to change the NLS_NCHAR_CHARACTERSET in 8i to UTF8 BEFORE upgrading to 9i/10g?
In (non-Unicode) SAP systems that were installed with Oracle 9i or lower, the national character set of the Oracle database is generally not set to UTF8, but either to AL16UTF16 (default on Oracle 9i) or to another value. However, to install and run an SAP J2EE server, UTF8 is re...
nls_nchar_characterset specifies the default character set of the database and is used for data types such as NCHAR, NVARCHAR2, and NCLOB. Note This variable cannot be modified. AttributeDescription Type varchar Default value AL16UTF16 Value range N/A Applicable scope Global Involved in serializa...