default full-text language Option
Use the default full-text language option to specify a default language value for full-text indexed columns. Linguistic analysis is performed on all data that is full-text indexed and is dependant on the language of the data. The default value of this option is the language of the server.
The value of the default full-text language option is used when no language has been specified for a column by using sp_fulltext_column. If a value is specified for which a linguistic analysis package is not available, neutral is used. Neutral should be used when the column contains data in multiple languages, or if the language being used is not supported.
The following linguistic analysis packages are part of Microsoft® SQL Server™ 2000.
| Language | Setting |
|---|---|
| Chinese Simplified | 2052 |
| Chinese Traditional | 1028 |
| Dutch | 1043 |
| English UK | 2057 |
| English US | 1033 |
| French | 1036 |
| German | 1031 |
| Italian | 1040 |
| Japanese | 1041 |
| Korean | 1042 |
| Neutral | 0 |
| Spanish Modern | 3082 |
| Swedish Default | 1053 |
It is possible for additional languages to be added (for example, independent software vendors may provide additional languages).
The default full-text language option replaces the language neutral full-text option in SQL Server version 7.0. When upgrading from SQL Server 7.0, the default full-text language value is set based on the values of SQL Server 7.0 configuration options Unicode locale id and language neutral full-text. This is done to allow compatibility with SQL Server 7.0 applications.
default full-text language is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change default full-text language only when show advanced options is set to 1.
To set the default full-text language option
Transact-SQL