Full Text Search Problems MSSQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full Text Search Problems MSSQL

Hi,<br /><br />I’m having a problem where I have a full-text catalogue setup on a table "candidates" where the "CVText" field is the text that is indexed. Some our our clients have noticed that, when refering to a candidates name, no CV’s are returned even thou the "CVText" field clearly contains it. The text is saved from our server via the Word Object and saved as Word HTML which sucks really as Word doesn’t make a good job at all.<br /><br />Would the HTML be causing a problem? Here is an example of "CVText":<br /><br />——————<br />&lt;div class=Section1&gt;<br />&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ /> class=MsoTitle&gt;&lt;i style=’mso-bidi-font-style:normal’&gt;&lt;span style=’font-size:<br />24.0pt;font-family:"Arial Black";color:black;text-decoration:none;text-underline:<br />none’&gt;ANDRE SANTANA&lt;o<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />&gt;&lt;/o<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />&gt;&lt;/span&gt;&lt;/i&gt;&lt;/p&gt;<br />…………….. etc<br />——————<br /><br />And part of the SQL statement is:<br />… INNER JOIN CONTAINSTABLE(candidates, *, ‘("ANDRE" AND "SANTANA")’) AS K …<br /><br />The HTML, as bad as it is, does contain "ANDRE" AND "SANTANA" so why is it not being returned?<br /><br />Thanks.
Hi ya, that is possible… the > and < symbols are not usually word separators in English, unlike . , ; :, etc. You could possibly test this by putting a space after > and before < around the person’s name and then see if MS Search picks it up (once the change is in MSSearch) I don’t know if there is a way in MS Search to tweak this… Cheers
Technet chathttp://www.microsoft.com/technet/community/chats/trans/sql/sq0529pm.mspx fyi (not a resolution though). Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I posted this on experts-exchange and I do have a fix. If your interested: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21855365.html
Thank you for posting the info about the fix.<br /><br />Haven’t they changed url from expertSexChange to experts-exchange recently? [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]
Blandy, appreciate your feedback in posting the resoulution.<br /><br />Mirko,<br />Yes after it has taken as one of cyber bloopers [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>