문자형 > ORACLE

• 목록

CREATE TABLE test (

GENDER CHAR(1), -- F,M (1 byte)

GENDER2 CHAR(3), -- 여,남 (3 byte)

GENDER3 CHAR(1 char), -- 여,남 (3 byte)

GENDER4 NCHAR(1) -- 여,남 (2 byte)

);

insert into test values('F','여','여','여');

select length(gender) from test; 

select lengthb(gender) from test;

select length(gender2) from test;

select lengthb(gender2) from test;

select length(gender3) from test;

select lengthb(gender3) from test;

select length(gender4) from test;

select lengthb(gender4) from test;

select * from NLS_DATABASE_PARAMETERS; --15 , 16번째 내용 캐릭터셋 비교