SQLTeam.com | Weblogs | Forums

Question on storing Text in Database


#1

Hi,
I have not had to store large amount of text in a database before. I know how to import it with SSIS of SQL code.
However, I want to be able to do Full Tet searches on it; an I know how to do that too; including setting it up and indexing it.
What I do not know, is how this is normally done. That is it would seem to me, and what I need to happen, is that each record holds the text. This is big text as it is from audio transcripts.
Can you tell me how do this please.

Thanks


#2

create a table with at least one nvacrhar(max) column. store the text in there. Then, set up the indexing. That's it.


#3

Okay thanks


#4

And use of FULLTEXT / FREETEXT perhaps?