Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text files storage & Fultext
- Thread starter andresmac
- Start date
ericbrunson
Technical User
I think you'll run into problems in that the internal formatting of file will screw up a text search. Try opening one of those files in a binary editor and you'll see what I mean. The strings are not necessarily contiguous.
- Thread starter
- #3
Ok I understand,
but:
1)There is any way to do a fulltext search on BLOB fields?
I know that Oracle have engines or filters to do fulltext on stored files.
2)Is possible storage files into TEXT fields same way than BLOB fields? (No matter what happend)
but:
1)There is any way to do a fulltext search on BLOB fields?
I know that Oracle have engines or filters to do fulltext on stored files.
2)Is possible storage files into TEXT fields same way than BLOB fields? (No matter what happend)
ericbrunson
Technical User
I think you could store it into a text field, you just take the risk of losing your high order bits in the non-printables, but that doesn't seem to matter to you.
Full steam ahead.
Full steam ahead.
- Thread starter
- #5
I would know:
1)What you mean with:
"losing your high order bits in the non-printables"
2)If I store files in TEXT fields, I can retrieve them without format lose?
3)There is any search engine, tool, filters or anything Open Source to do fulltext search in MySQL's BLOB fields?
Thank you in advance, your responses are very useful
1)What you mean with:
"losing your high order bits in the non-printables"
2)If I store files in TEXT fields, I can retrieve them without format lose?
3)There is any search engine, tool, filters or anything Open Source to do fulltext search in MySQL's BLOB fields?
Thank you in advance, your responses are very useful
ericbrunson
Technical User
1) English ASCII printables (charaters that form the readable text that you see on the screen) only require 7 bits to be stored and represented because there are fewer than 128 of them, but the full ASCII character set is 8 bits, or 256 characters.
Many applications that expect to be storing readable ASCII, such as internet mail or a text field in a database, don't bother storing that 8th, or "high order" bit. This is why you have to encode documents sent in mail to only use 7 bit ASCII. This is what you *may* lose if you cram a binary into a text field.
2) If you lose the high order bit, then no. The easiest way to find out would be to try it.
3) I don't know. Probably not.
Many applications that expect to be storing readable ASCII, such as internet mail or a text field in a database, don't bother storing that 8th, or "high order" bit. This is why you have to encode documents sent in mail to only use 7 bit ASCII. This is what you *may* lose if you cram a binary into a text field.
2) If you lose the high order bit, then no. The easiest way to find out would be to try it.
3) I don't know. Probably not.
- Status
Similar threads
- Locked
- Question