Back to Top
The nuts and bolts for
Creative web development

How do I change the language of a FullText catalog?

Question:



How do I change the language of a FullText catalog in SQL server ?

Answer:


You must use a system stored procedure to turn a full-text catalog to a different language. There is an example below:

EXEC sp_fulltext_column InfoCategorias, Keywords, 'add', 0xC0A

Where "InfoCategorias" is the name of the table, "Keywords" is the name of the field and "0xC0A" is the code of the Spanish language.

Marcellino Bommezijn

Marcellino BommezijnMarcellino Bommezijn is one of the managers at dmxzone.com. He is a contributor on the tutorials section.

Owner of Senzes Media (http://www.activecontent.nl) which provides professional services and web applications for mid-sized companies.

ActiveContent CMS is the ASP.NET Content Management solution that is used for building professional and rich-featured websites.

See All Postings From Marcellino Bommezijn >>

Share this Article