How do I change the language of a FullText catalog?
September 4, 2002 by Marcellino Bommezijn

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

Place your comment about How do I change the language of a FullText catalog?




You must me logged in to write a comment
Comments

Be the first to place a comment