Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does FTS thesaurus support CDATA sections? Expand / Collapse
Author
Message
Posted Thursday, December 18, 2008 12:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2014 10:07 AM
Points: 6, Visits: 76
Hello,

I am testing a Full-Text Search thesaurus, and have not been able to get it to accept CDATA sections. I want to be able to specifiy stitution tag text that can include punctuation (such as a hyphen). FTS will not parse the thesaurus if sub elements contain some punctuation (- ' # $ etc.), and logs an error. If I use a CDATA section, an error is also logged, but in both cases where an error occurs, FTS continues to run and return (incorrect) results. Not sure why it returns any results if the thesaurus is invalid.

Here is the Windows Event Log message:


The thesaurus file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\tsenu.xml for lcid 1033 has invalid format. Please edit the file and correct it. Use retail tracing for detailed error description. See user documentation on fulltext retail tracing.Component: MicrosoftIndexer

Any thoughts on how to solve the punctuation problem? Here is the simplified thesaurus:



















<!-- Does not work

-->

<!-- Does not work

-->







Thanks


--------------------------------------------------------------------------------
Harold
Post #622393
Posted Thursday, December 18, 2008 12:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2014 10:07 AM
Points: 6, Visits: 76
Sorry, the FTS thesuarus XML file does not display. What I want to know is if there is a way to include some punctuation in the the text conent of elements, whether by using CDATA sections or some other method. Thank you
Post #622395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse