You can change default full-text language server configuration option in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL. default full-text language option specifies a default language value for full-text indexes. Linguistic analysis is performed on all data that is full-text indexed and is dependent on the language of the data. The default value of this option is the language of the server. For a localized version of SQL Server, SQL Server Setup sets the default full-text language option to the language of the server if an appropriate match exists. For a non-localized version of SQL Server, the default full-text language option is English.
Change Parameter With SQL Server Management Studio
- Open Object Explorer, right-click a server and select Properties.
- Click Advanced Step.
- Under Miscellaneous, use Default Full Text Language to specify a default language value for full-text indexed columns.
Change Parameter With Transact-SQL
I will change option to 1055 that is Turkish language code. You can see LCID codes of language with below query. You can change with below queries.
select * from sys.fulltext_languages;
USE
;
GO
EXEC sp_configure ‘show advanced options’, 1 ;
GO
RECONFIGURE
GO
EXEC sp_configure ‘default full-text language’, 1055 ;
GO
RECONFIGURE
GO