오라클과 NLS

오라클과 NLS

• KO16KSC5601
• KO16MSWIN949
• UTF8
• AL32UTF8

http://www.oracle.com/technology/global/kr/pub/columns/oracle_nls_1.html

 

 

select * from NLS_DATABASE_PARAMETERS where PARAMETER='NLS_CHARACTERSET'

 

set NLS_LANG=KOREAN_KOREA.AL32UTF8

다국어 처리를 위해

update sys.props$ set value$='AL32UTF8' where name='NLS_CHARACTERSET';
update sys.props$ set value$='AL32UTF8' where name='NLS_NCHAR_CHARACTERSET';