Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    5

    Question Unanswered: Full text indexing question

    Hi,

    I am using full text indexing to index an image column where I am storing HTML documents. Currently I have an extra column in my table storing the file extension (htm) so the indexer knows which filter to use for every row.

    HTML is the only format I'll be indexing, so is there a way for me to set this somewhere else so I don't have to have a column full of htm values - this seems really wasteful, those htm's add up when there are millions of rows...

    Thanks!
    Rob

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447
    Why don't you use two separate tables, one for you image data, and one for your HTML pages. You may consider in the last case to store the HTML pages as text or ntext.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Aug 2002
    Posts
    5
    I don't have any "image data" - just html files stored in an image datatype column. My specific data structure isn't really relevent - is there an alternative to the file extension column for full text indexing (because it will always contain the same value)?

    Hope this makes it clearer

    Rob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •