typed dataset - all my fields are padded?

  • Thread starter Thread starter Jeff Jarrell
  • Start date Start date
J

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
 
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.
 
Back
Top