Search binary (byte[]) data in Sql Server database?

Question

0.00/5 (No votes)

See more:

I have to save some rich text into my sql server database, and my solution is serializing the string of rtf (achieved from RichTextBox.Rtf) into a stream, then converting this stream into an array of bytes (byte[]), and lastly, save these bytes into a field of binary (or image) of a Sql server table. This solution can store the richtext well but I don't know how to search the saved data for some keyword, could you tell me how to do that?
If possible, could you help me achieve both of the two purposes: 1. Save richtext.
2. Search the saved richtext.
Your help would be highly appreciated!

Posted 23-Dec-11 3:04am

supernorb

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2011-12-23T03:08:00

Solution 1

Quickly comes in mind that why not store the rtf in binary field and the text portion of the rtf in a separate field that would be searchable using normal SQL functions.

Posted 23-Dec-11 3:08am

Wendelius

Comments

supernorb 23-Dec-11 22:48pm

That would work greatly. But do you think the database size will double the normal size?
Or that is the expense we have to accept? Don't we have any other ways?
If not, I would use that way and thank you for the great solution.

Wendelius 24-Dec-11 3:06am

The size will certainly grow. I don't think it's going to double since formatting are not stored twice.

Depending on the situation perhaps another solution could be to store the text portion inside the database and the rtf files using filestream. Have a look at: How to store and fetch binary data into a file stream column[^]

supernorb 24-Dec-11 15:42pm

Thank you so much!
I have just known of a new tech from you.

Wendelius 24-Dec-11 16:45pm

You're welcome, glad it helped :)