I have a c# winform with a SQL Server 2005 backend. When I update my database from textboxes in the form, in one particular table all the nvarchar entries are padded with white space. This doesn't happen for other tables.
All the fields that are being padded are nvarchar (not nchar), and are padded to their maximum length. If I run the query manually and enter values myself without using the form, then everything works fine
Any ideas what's going on???