Sql server datastore

Hi,

You have to use datatype as nvarchar(max) or varchar(max) for storing these type of values

Thanks & Regards,
Software Engineer,
Pradeep Kumar

Sekar.c, if this helps please login to Mark As Answer. | Alert Moderator

Please mark as Answer if helps:


Hi Sekar.c ,

if the column accepts fixed length value every time then use Char and
if datalenght in too much variable then only use varchar(lenght) type
here i dont think you should take nvarchar datatype as it takes more bytes 2 times more than varchar
which take more size on disk and perform slower,


example :


create table #table (data varchar(20))
GO

insert into #table
select 'Net I (0.00 B/s)'


Select * From #table



Visit my blog : www.tutorialsqlserver.com

Sekar.c, if this helps please login to Mark As Answer. | Alert Moderator