LONGBLOB is not complete

[Sławomir Małolepszy]

Hello,

I use .NET Connector. I want to send to database long string (it's xml file). In database I have a table with column which type is LONGBLOB. I use MySqlCommand and when I debug the application in MySqlParameter I have all text, which I want to send to database. Everything is successful, but in database after ExecuteNonQuery the text, which is in database isn't complete, it's broken in the middle and it's place isn't permament.

My code:

MySqlCommand cmd = new MySqlCommand(sql, tr.Connection, tr);

cmd.Parameters.Add("?pUPRAWNIENIA", MySqlDbType.LongBlob);
cmd.Parameters["?pUPRAWNIENIA"].Value = this.GrupaUprawnienia;
cmd.ExecuteNonQuery();


Do you know what's wrong?

Thanks for answers