title: Full Text search on a Varbinary Column - Is it possible to use a mime type rather than a file extension as my Type Column?
body: <p>I am setting up full text search on an existing database. We have Document table with the following schema:</p>
  
  <pre><code>ID int Not Null,
  Data varbinary(max) Not Null
  MimeType varchar Not Null
  </code></pre>
  
  <p>I want to use full text search on the data column, using the mimetype to specify the document type.</p>
  
  <p>I was hoping it would be possible to register new types into whatever tables are used when you use the view <code>sys.fulltext_document_types</code>. Is this possible?</p>