ORACLE NVARCHAR2 中文乱码

最新推荐文章于 2024-07-04 16:24:31 发布

风林火山915

最新推荐文章于 2024-07-04 16:24:31 发布

阅读量3.2k

点赞数

分类专栏： db

本文链接：https://blog.csdn.net/qq_25713179/article/details/81326680

版权

db 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

VARCHAR2 需要字符集UTF8

NVARCHAR2需要字符集AL16UTF16

select * from sys.nls_database_parameters;

SQL> alter system checkpoint;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

2、启动数据库
SQL> STARTUP MOUNT EXCLUSIVE;
ORACLE instance started.

Total System Global Area 2471931904 bytes
Fixed Size 2291376 bytes
Variable Size 671091024 bytes
Database Buffers 1778384896 bytes
Redo Buffers 20164608 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter system set aq_tm_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP

ORACLE instance started.

Total System Global Area 2471931904 bytes
Fixed Size 2291376 bytes
Variable Size 671091024 bytes
Database Buffers 1778384896 bytes
Redo Buffers 20164608 bytes
Database mounted.
Database opened.