full-text indexing on multilanguage data

[vadimg]

SQLServer 2005
SQLServer 2000


Can sql server full-text index and apply appropriate word breakers for a unicode column? Data in the column can be in any language.

if so, what are the drawbacks?

would it be better to keep data separate (1 column for every language or 1 table for every language)?

again -- what are the pros and cons..

Thanks!

 

[mrdenny]

According to BOL

Use neutral when a column contains data in multiple languages or in an unsupported language.

You can read up more under the heading "full-text indexes, linguistic analysis" in BOL. There is also so info at "full-text queries, languages supported".

I've never tried storring more than one language in a single full text field, but I'd recommend one language per table so you can filter based on the users language.

(This is from SQL 2000, I've got no idea on SQL 2005).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)