Values Getting Truncated When Sent To SQL Server

I have a standard asp.net form and a single database table that I’m trying to pass data into. There are three nvarchar fields of lengths 50, 150, and 2400. Whenever I do an insert or update it truncates all data except for the first character. So if I pass “asdfasdf�, the db field will only receive “a�.





The data going from the form is correct; it gets truncated somewhere after the ExecuteNonQuery() call.





Here is the c# code:





public bool InsertCareer (DataRow row) {


SqlConnection conn = new SqlConnection(connStr);


try {


SqlCommand cmd = new SqlCommand();


cmd.CommandType = CommandType.StoredProcedure;


cmd.CommandText = storedProcs[(int)StoredProcedures.Insert];


cmd.Connection = conn;


cmd.Parameters.Add("@pkCareerID", row[0]);


cmd.Parameters.Add("@jobTitle", row[1]);


cmd.Parameters.Add("@postedDate", row[2]);


cmd.Parameters.Add("@submitBy", row[3]);


cmd.Parameters.Add("@department", row[4]);


cmd.Parameters.Add("@description", row[5]);


cmd.Parameters.Add("@intranet", row[6]);


cmd.Parameters.Add("@public", row[7]);





conn.Open();


cmd.ExecuteNonQuery();


return true;


} catch (Exception ex) {


//… stuff


return false;


} finally {


conn.Close();


}


}








This is the sproc code:





CREATE PROCEDURE dbo.zak_CareersIU_sp


@pkCareerID int,


@jobTitle nvarchar,


@postedDate datetime,


@submitBy datetime,


@department nvarchar,


@description nvarchar,


@intranet bit,


@public bit





AS





IF EXISTS (SELECT pkCareerID FROM zak_Careers WHERE pkCareerID=@pkCareerID)





BEGIN


UPDATE zak_Careers SET


jobTitle=@jobTitle,


postedDate=@postedDate,


submitBy=@submitBy,


department=@department,


[description]=@description,


intranet=@intranet,


[public]=@public


WHERE


pkCareerID=@pkCareerID


END


ELSE


BEGIN


INSERT INTO zak_Careers


(jobTitle, postedDate, submitBy, department, [description], intranet, [public])


VALUES


(@jobTitle, @postedDate, @submitBy, @department, @description, @intranet, @public)


END





Please let me know if you have any ideas!


thanks