Export (0) Print
Expand All

default full-text language Option

SQL Server 2000

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

SQL-DMO

See Also

RECONFIGURE

Setting Configuration Options

sp_configure

sp_fulltext_column

Show:
© 2014 Microsoft