CHAR Data Type

Query:

drop table char_t;  

create table char_t(name char(10));

insert into char_t values( 'A ' );

insert into char_t values( ' A' );

insert into char_t values( 'A' );

commit;

Output:

select name, length(name )from char_t;

NAME       LENGTH(NAME)

---------- ------------

A                    10

 A                   10

A                    10