CHARACTERSET

 

언어셋 정보 확인 및 업데이트
 
SELECT NAME,VALUE$ FROM SYS.PROPS$ WHERE NAME IN ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET','NLS_LANGUAGE') ORDER BY 1;
 
select value$ from sys.props$ where name='NLS_CHARACTERSET';
select value$ from sys.props$ where name='NLS_NCHAR_CHARACTERSET';
select value$ from sys.props$ where name='NLS_LANGUAGE';
select value$ from sys.props$ where name='NLS_TERRITORY';
 
update sys.props$ set value$='AL32UTF8' where name='NLS_CHARACTERSET';
update sys.props$ set value$='AL16UTF16' where name='NLS_NCHAR_CHARACTERSET';
update sys.props$ set value$='AMERICAN' where name='NLS_LANGUAGE';
update sys.props$ set value$='AMERICA' where name='NLS_TERRITORY';
 
참고- http://glove88.tistory.com/33
- 오라클 언어셋 변경

https://kr.forums.oracle.com/forums/thread.jspa?threadID=420882