Friday, March 30, 2012

problem in freetext search in MS SQL Server

hi
i have problem in fulltex search, when i search any
english word it give me perfect result.
In my table i have define fulltext search on a column
name content_html, data type of column is ntext it
stores htlm content.
now when i search any unicode character(gujarati word)
it shows me content which not contain the search
value.
if anyone know the solution
pls help urgent
What word breaker are you using? You really should store your data in
columns of the image data type and have a document type column containing
the value of htm or html.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mahesh" <mahesh.anjani@.gmail.com> wrote in message
news:1141816487.482238.60840@.j33g2000cwa.googlegro ups.com...
> hi
> i have problem in fulltex search, when i search any
> english word it give me perfect result.
> In my table i have define fulltext search on a column
> name content_html, data type of column is ntext it
> stores htlm content.
> now when i search any unicode character(gujarati word)
> it shows me content which not contain the search
> value.
> if anyone know the solution
> pls help urgent
>

No comments:

Post a Comment