typed dataset - all my fields are padded?

[Jeff Jarrell]

I have a strongly typed dataset. It seems as though all of my sql chars and
varchar fields come through from mssql server padded out to the length of
the field. Anything I can do about it in Ado.net?

Thanks,
jeff

 

[Miha Markic [MVP C#]]

Hi Jeff,

I guess this is due char Sql Server's column type.
The best thing you can do is to switch to varchar instead at the sql
server's level.
While there should be no padding for varchars unless the values are stored
with trailing blanks in the database.