|
Home > Archive > SQL Server Full-Text Search > March 2006 > problem in freetext search in MS SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problem in freetext search in MS SQL Server
|
|
| Mahesh 2006-03-08, 7:24 am |
| 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
| |
| Hilary Cotter 2006-03-08, 9:24 am |
| 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.googlegroups.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
>
|
|
|
|
|