Menu
Changing one full-text index column Language (LCID) to Neutral when the others are English results in the following error:
System.Data.SqlClient.SqlException (0x80131904):
Full-text table or indexed view has more than one LCID among its
full-text indexed columns
Repopulating the index does not resolve the error.
If SQL Server lets me specify different Languages for every full-text column, then surely there must be a way to bypass this error?
232
To create a full text index choose your table and right click on that table and select “Define Full-Text Index” option. Now select Unique Index. It is compulsory that for “Full Text Index” table must have at least one unique index. Select columns name and language types for columns.
A full-text index is a special type of index that provides index access for full-text queries against character or binary column data. A full-text index breaks the column into tokens and these tokens make up the index data.
Use the DROP clause only on columns that have been enabled previously for full-text indexing. Use TYPE COLUMN and LANGUAGE with the ADD clause to set these properties on the column_name.
Only one full-text index is allowed per table or indexed view, and each full-text index applies to a single table or indexed view.
You should check if all the columns that are full-text indexed have the same language word breaker. Go to context menu of the table--> Full text index--> Properties. In the left side, you'll find Columns. Select it and edit all language word breaker to be the same. I hope you find this usefull
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
