oracle的默认编码是,ORACLE 默认编码 GBK -UTF8编码

查看oracle数据库字符集：

select userenv('language') from dual;

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  135337420 bytes

Fixed Size                   452044 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 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 character set INTERNAL_USE UTF8

或者

SQL> alter database character set zhs16gbk

2  ;

alter database character set zhs16gbk

*

第 1 行出现错误:

ORA-12716: ??? CLOB ???, ?? ALTER DATABASE CHARACTER SET

alter database character set internal_convert zhs16gbk;

posted on 2008-02-03 10:28 坏男孩 阅读(6715) 评论(1)  编辑  收藏 所属分类: ORACLE篇章