linux下更改oralce字符集
2126 点击·0 回帖
![]() | ![]() | |
![]() | linux下oralce更改字符集,发现乱码问题,一查发现所装的oracle不是中文字符集,更改之。。。 查询当前的字符集 Sql代码 select userenv('language') from dual; 修改为zhs16gbk字符集 Sql代码 conn / as sysdba; shutdown immediate; startup mount; alter system enable restricted session ; alter system set JOB_QUEUE_PROCESSES=0; alter system set AQ_TM_PROCESSES=0; alter database open; alter database character set internal_use zhs16gbk; shutdown immediate; startup; | |
![]() | ![]() |