Compressing RTF for Database

[mrpolla]

Hello,

I am developing an application where the user saves a chosen RTF file to a SQL Server database. My problem is that if the file contains an image, the binary becomes too big. Although the database has enough space, it's not very nice to use up space you could save....

To give an example:

RTF binary with two text lines ("ABC / efg") = 156 Bytes
Same 2 lines + 32 kB image = 2.2MB

I am still confused on which is the best way to solve this. I have thought about creating an "images" table in my database and using a markup to fetch the image when the file is loaded.

A compression algorythim would also be great but I don't know how efficient it could be.

What would be the best strategy to solve this??

[formlesstree4]

I'm not sure how the RTF format stores images; might convert the data to Base64 which could explain the rather large size increase somewhat.

Regardless, you could invest in the GZipStream and convert your data to binary before saving it, then just store it all in a binary slot.

[mrpolla]

Hey formlesstree4,

thanks for your reply. I ended up using GZipStream (thanks for the suggestion). However, the file is still a little bit too big (700kB).

I am using a RichTextBox as an editor where the user can copy and paste images (or add them with an Openfiledialog).

                Dim image As Image = image.FromFile(OpenFileDialog1.FileName)
                Clipboard.Clear()
                Clipboard.SetImage(image)
                Me.RichTextBox1.Paste()

It is pasted automatically so I think it's converted to bitmap. Is there any way to insert this image into the text box without converting it to bitmap (which is what I think it does)?