Unwanted NVARCHAR Padding

I've created an asp.net page that takes the content of text boxes and writes them to a sql table.





The problem is that when I examine the resulting data in the SQL database, I find that the fields written to have had padding added (up to the maximum size of the fields).





I was under the impression that fields of type NVARCHAR did not store padding (only the no of characters being stored).





I've checked it's not the text boxes on the aspx page by explicitly posting values instead of the boxes content and the same thing happens.





Help





example of function i'm using to post data:





Function AddNews(ByVal Category As String, ByVal ApplicRole As String, ByVal NewsType As String, ByVal Description As String, ByVal News As String, ByVal Hyperlink As String, ByVal Email As String, ByVal BirthDate As Date, ByVal KillDate As Date, ByVal Parent As String) As Integer


Dim connectionString As String = ConfigurationSettings.AppSettings("AuthentConnection")


Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)


Dim queryString As String = "INSERT INTO [News]([Category],[ApplicRole],[NewsType],[Description],[News],[Hyperlink],[Email],[BirthDate],[KillDate],[Parent]) VALUES (@Category,@ApplicRole,@NewsType,@Description,@News,@Hyperlink,@Email,@BirthDate,@KillDate,@Parent)"


Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand





dbCommand.CommandText = queryString


dbCommand.Connection = dbConnection





Dim dbParam_Category As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_Category.ParameterName = "@Category"


dbParam_Category.Value = Category


dbParam_Category.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_Category)


Dim dbParam_ApplicRole As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_ApplicRole.ParameterName = "@ApplicRole"


dbParam_ApplicRole.Value = ApplicRole


dbParam_ApplicRole.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_ApplicRole)


Dim dbParam_NewsType As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_NewsType.ParameterName = "@NewsType"


dbParam_NewsType.Value = NewsType


dbParam_NewsType.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_NewsType)


Dim dbParam_Description As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_Description.ParameterName = "@Description"


dbParam_Description.Value = Description


dbParam_Description.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_Description)


Dim dbParam_News As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_News.ParameterName = "@News"


dbParam_News.Value = News


dbParam_News.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_News)


Dim dbParam_Hyperlink As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_Hyperlink.ParameterName = "@Hyperlink"


dbParam_Hyperlink.Value = Hyperlink


dbParam_Hyperlink.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_Hyperlink)


Dim dbParam_Email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_Email.ParameterName = "@Email"


dbParam_Email.Value = Email


dbParam_Email.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_Email)


Dim dbParam_BirthDate As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_BirthDate.ParameterName = "@BirthDate"


dbParam_BirthDate.Value = BirthDate


dbParam_BirthDate.DbType = System.Data.DbType.Date


dbCommand.Parameters.Add(dbParam_BirthDate)


Dim dbParam_KillDate As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_KillDate.ParameterName = "@KillDate"


dbParam_KillDate.Value = KillDate


dbParam_KillDate.DbType = System.Data.DbType.Date


dbCommand.Parameters.Add(dbParam_KillDate)


Dim dbParam_Parent As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_Parent.ParameterName = "@Parent"


dbParam_Parent.Value = Parent


dbParam_Parent.DbType = System.Data.DbType.StringFixedLength


dbCommand.Parameters.Add(dbParam_Parent)





Dim rowsAffected As Integer = 0


dbConnection.Open


Try


rowsAffected = dbCommand.ExecuteNonQuery


Finally


dbConnection.Close


End Try





Return rowsAffected


End Function