SQL Data Type for RTF

[gmhanna]

Hi, I'm trying to store RTF data inside of Transact-SQL and have used a data type of TEXT, however when retrieving the data from the database all I am receiving is the actual text, all of the RTF markup is gone and I am just receiving plain text. My question is what should I be using for a data type, since TEXT is not working the way I thought it would. Thank you, Glenn

Glenn

[Lost User]

gmhanna wrote:

what should I be using for a data type

TEXT will do; it can also hold text with markup, like RTF and HTML. What property are you writing to the field? Make sure that you're saving the Rtf[^] property to the database, and not the Text[^]. The first will contain all text, with the Rtf-markup. The second property, "richTextBox1.Text", only contains plaintext.

I are Troll :suss:

[gmhanna]

Hi Eddy, I have been trying to locate how this is attached. I am using a "Data Source" and the control is bound to the data source. I have been scouring the code trying to see something like rtftextbox.text or rtftextbox.rtf, but I'm not locating it. This control was placed on the form by dragging the RTF control from the data source and dropping it onto the form. I usually code the SQL stuff by hand but thought the automated tool was cool. Thank you,

Glenn

[Lost User]

gmhanna wrote:

I have been scouring the code trying to see something like rtftextbox.text or rtftextbox.rtf, but I'm not locating it.

That's probably in InitializeComponent(), binding the property.

gmhanna wrote:

I usually code the SQL stuff by hand but thought the automated tool was cool.

It can save a lot of boring typing-work, but you'll get surprises like these in return :)

I are Troll :suss:

[gmhanna]

I have this line of code in the InitializeComponent() for the binding. I could not find a definition for the word "Text", but I think what you are hinting at is I should try changing this to Rtf?

this.commentsRichTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.reunionBindingSource, "Comments", true));

Thank you,

Glenn

[Lost User]

That should work, but keep in mind that it's a generated file; I don't know whether the designer will pick up the changes correctly.

I are Troll :suss:

[Simon_Whale]

Just to be picky, if your using SQL 2005 or later i would use VARCHAR(MAX) As TEXT has been decpreciated and should be removed in the next version of SQL

Marc Clifton wrote:

That has nothing to do with VB. - Oh crap. I just defended VB!

[gmhanna]

Thank you for the information. I am currently using SQL Sever 2008 R2, so I'll change it.

Glenn