Converting text into rtf format in mssql

Question

Hi everyone,

I have data that is in word document that I want to insert into the database, this data is formatted and I will like to save the formats in the database as well using the rtf format.

Can someone help me on how I can generate the rtf format for the data in the word document so that I can store the rtf instead of the plain text in the database.

Thanks

Answer 1

SQL Server does not really care about the format. If it is text data you can save the document in an nvarchar(MAX) or varchar(MAX) column. If the data is binary, such as an .docx file, you need to use varbinary(MAX). I believe RTF is a text format, but I am not sure. varbinary(MAX) will always work any way.

If you want to transform the document, you need to do this outside SQL Server, and for how to do it - this is the completely wrong place to ask.

SQL Server receives the generated bytes and that is what it returns. SQL Server never interpretes the bytes on its own account - with one exception: if you add a full-text index on a database, it is able to read PDFs, Word documents etc, provided that you somewhere store information about the format.

Answer 2

Hi @tobz ,

Please refer to the following steps to set：

Step1-Open your word file,find the'File' in the upper left corner, as shown in the figure

Step2-Then click "File" in the upper left corner, and find "Save As" in the submenu, as shown in the figure

Step3-In the pop-up "Save As" window, select the location to save the file, modify the file type to "RTF" format, and click Save. As shown

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table