Indexing special character (spanish) for searching full text search SQL 2008

• Cesar A Paez-449617

  SSC Rookie

  Points: 25

  More actions

  August 13, 2009 at 1:53 pm

  #208572

  Hi

  I have no experience in full text search.

  I want to perfom an index for a table with a column (type txt) where I have some text in spanish with words that contains characters like á ( "á" character).

  I need to index these special characters as characters with accent because I need to search a word like this : "más" ..then full text should return to me records with "más","mas","más".

  Is this possible with SQL 2008..???

  Thanks in advance

  Cesar