SQL Server Performance Forum – Threads Archive

rtf conversion

Hello,
Does anyone know of a way to store rich text format in a database? Is there a conversion tool that I could buy? I use borland c++ builder 6.0 and would like to store *.rtf text directly in the database. Thanks in advance,
Ben

I wouldn’t even mind creating a function myself that does the conversion to text, but I don’t know where to find out how you would store in a database that a word has some type of formatting on it. I assume that it would be similar to html or something like that but I can’t find any help or tables stating the conversion. Thanks,
Ben

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp might give you some ideas. You don’t need a conversion tool when storing in an image column. Your application layer is responsible for correct interpretation of that data. Frank
http://www.insidesql.de
http://www.familienzirkus.de

You can use a column defined with the IMAGE datatype and search as well as view the RTF documents directly and with correct formatting from SQL Server. The latter I expect you should be able to handle with one or more of the below KB articles, you can use the following code to import and FT Index the RTF documents. Firstly, you will need to download the RTF IFilter (Indexing Filter) fromhttp://www.microsoft.com/sharepoint…/rtf_filter.asp and install it. Secondly, you can use the following T-SQL code to create a table for your RTF documents and use TextCopy.exe (shipped with SQL 2000) as the upload method in this example. Note, you can also use ADO Stream or other methods referenced in the KBAs. Lastly, if you’re well versed with XML then yes its easy and durable to convert RTF to XML and manage with SQL database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Few links to about handling images/documents in the database : http://www.databasejournal.com/features/mssql/article.php/1443521
http://www.allisonmitchell.com/Articles/TextCopy.htm
http://support.microsoft.com/default.aspx?scid=kb;EN-US;308042
http://support.microsoft.com/default.aspx?scid=kb;en-us;242875 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for your help. I have a control that I use in Borland to talk to SQL server. I noticed that there are methods in that control for writing blob’s to image columns. Thanks again for your help,
Ben

]]>