I am creating a winform app in C# to store formatted text from a rich text box to MySQL database, which can be retrieved back to the rich text box. The database field is a VARCHAR and my code is something similar to below. But I'm getting "file not in correct format" error. Can anyone tell what could be the problem? Is the VARCHAR field okay to store it or should I change it to a BLOB?
string rtfText = this.richTextBox1.Rtf;
// save rtfText to database field as varchar
// reload rtfText from database as string
this.richTextBox1.Rtf = rtfText;