Anurag Singh

Anurag Singh

  • NA
  • 89
  • 65k

How will bytes it will take in sql???

Apr 30 2015 2:36 AM
Hi,
 
I have a column NAME and I am defining its datatype like: varchar(50), char(50), nvarchar(50) and nchar(50). And after that if I'll print 'ANURAG', then how much bytes it will take in all conditions???
 
Means:
 
Name varchar(50) then I'll print 'ANURAG' then bytes=???
Name char(50) then I'll print 'ANURAG' then bytes=??? 
Name nvarchar(50) then I'll print 'ANURAG' then bytes=??? 
Name nchar(50) then I'll print 'ANURAG' then bytes=??? 
 
Thanks:
Anurag Singh 

Answers (4)