Groups | Blog | Home
all groups > sql server full text search > august 2006 >

sql server full text search : LCID indexed columns


Hilary Cotter
8/14/2006 9:00:43 AM
It seems that in your full-text query are querying more than one column and
one of the columns is using a different word breaker. They must all use the
same word breaker or use the same language in your query using the language
predicate.

--
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



[quoted text, click to view]

André Nobre
8/14/2006 9:39:01 AM
Hi all,
I´m having this error when I try to search sql server 2005 in Visual Studio
2005 / Commerce Server 2007, and I don´t know how to resolve it. I´ve alredy
tried to delete, modify the Full-Text Index on my table, etc, etc, but
doen´t did any difference. Any tips?

"Full-text table or indexed view has more than one LCID among its full-text
indexed columns. at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection (...)"

Thanks!

André Nobre
8/14/2006 10:28:20 AM
Thanks Hilary, the language for word breaker was empty, I selected English
and it executed ok.

Thanks again!


[quoted text, click to view]

AddThis Social Bookmark Button