且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在Oracle 11g XE上更改NLS字符集参数

更新时间:2023-11-18 23:40:04

这对我有用,其中应用程序正在检查 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