在Oracle 11g XE上更改NLS字符集参数 [英] Change NLS Character set parameters on Oracle 11g XE

问题描述

我正在使用Oracle 11g Express Edition.当前，当我使用SELECT * FROM nls_database_parameters;检查NLS字符集参数时，它会提供默认值:

I am using Oracle 11g Express Edition. Currently when I check NLS character set parameter using SELECT * FROM nls_database_parameters; it gives the default values:

NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

我想将这两个参数都设置为UTF8.我该怎么办?我刚刚安装了Oracle 11g XE，因此除了Oracle本身所需的数据之外，没有其他数据.

I want to set both these parameters to UTF8. How can I do so? I have just installed Oracle 11g XE, so there is not data except those required by Oracle itself.

推荐答案

这对我有用，其中应用程序正在检查 UTF8 rather than AL32UTF8 .

This worked for me where an application was checking for UTF8 rather than AL32UTF8 .

SQL> shutdown immediate;

SQL> startup restrict

SQL> select name from v$database;

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8 ;

SQL> select value from NLS_DATABASE_PARAMETERS 
     where parameter=’NLS_CHARACTERSET’;

SQL> shutdown immediate;

SQL> startup

这篇关于在Oracle 11g XE上更改NLS字符集参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！