Home Forums SQL Server 2008 T-SQL (SS2K8) char(??) vs varchar(??) RE: char(??) vs varchar(??)
subbu1
Hall of Fame
Points: 3281
More actions
October 29, 2012 at 10:20 pm
#1553992
pls check below code...
declare @var_chr char(50)='abc'
declare @var_varchr varchar(50)='abc'
select DATALENGTH(@var_chr) chr,DATALENGTH(@var_varchr) var
O/P:chrvar
503