Char(20) = 'name' varchar2(20)='name' When comparing these two values, are the spaces padded in char are considered or not? Are both values equal?

ashwani_kumar527

 Profile Answers by ashwani_kumar527 

• Sep 21st, 2007

 

In Char type spaces will be padded after 'name' uptp max length 20.
in Varchar spaces will not be padded.

mala

• Sep 26th, 2007

 

While comparing a char value to a Varchar spaces will be counted so your example fails

Regards
Mala

Sudhir Sorout

 Profile Answers by Sudhir Sorout 

• Feb 8th, 2008

 

Spaces will pad, both value will be different, Use this procedure your doubt will be clear

create or
replace procedure test2
as
   x varchar(20):='sudhir';
   y char(20):='sudhir';

   begin
   if(x=y) then
     dbms_output.put_line('both are equal');

   else
     dbms_output.put_line('both are not equal');

   end
if;
end;

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 13th, 2008

 

You can check it using the following procedure

create or replace procedure test as

v_name1  char(20) := 'name';
v_name2  varchar2(20) := 'name';

begin

if v_name1 = v_name2 then
dbms_output.put_line('Both the words are same');
else
dbms_output.put_line('Both the words are different');
end if;
end;

The output is
Both the words are different.

if rtrim(v_name1) = v_name2 then

if you use rtrim for char data it will diplay the message
two words are same.

This is because
Char is a fixed length datatype and values are padded with blank spaces to match specified length.
Varchar2 is variable length datatype.

mosam

 Profile Answers by mosam 

• May 20th, 2008

 

ans is both values are not equal  char(20)='name' covered in memorey areea is 20 but varchar2(20)='name' covered in memorey areea is 4 becoze char is fixed lenth char data type but varchar2 is variable lenth char data type

javedans

 Profile Answers by javedans 

• Jul 8th, 2009

 

Spaces will be padded with y variable,its means y will store y='sudhir              ' . while x only store 6 six character so both string will not be equal

create or replace procedure test2 as
   x varchar(20):='sudhir';
   y char(20):='sudhir';
   begin
   if(x=y) then
     dbms_output.put_line('both are equal');
   else
     dbms_output.put_line('both are not equal');
   end if;
end;

Rpradeep

 Profile Answers by Rpradeep Questions by Rpradeep

• Jul 7th, 2014

 

Yes but small difference
if we use char (20) it will padd the blank space
where as varchar 2(20) it will not padd blank space..

chinnu

• Jan 27th, 2015

 

char datatype is fixed,but it cant be reused. eq: char(10) -- elena,first 5 characters will be filled remaining field are padded.
varchar2 datatype fixed,but it can be reused. eq: varchar2(10) -- elena, first 5 characters will be filled and remaining fields are reused.

suvijyo

• Feb 2nd, 2015

 

Code