oracle(오라클) character set 확인방법

Character set 확인

select name, value$

from props$

where name in ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');

 

 

Character set 수정

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

 

commit;