Revert the Word Breakers Used by Search to the Previous Version

 

Applies To: SQL Server 2016

SQL Server 2016 installs and enables a version of the word breakers and stemmers for all languages supported by Full-Text Search with the exception of Korean. This topic describes how to switch from this version of these components to the previous version, or to switch back from the previous version to the new version.

This topic does not discuss the following languages:

  • English. To revert or restore the English components, see Change the Word Breaker Used for US English and UK English.

  • Danish, Polish, and Turkish. The third-party word breakers for Danish, Polish, and Turkish that were included with previous releases of SQL Server have been replaced with Microsoft components.

  • Czech and Greek. There are new word breakers for Czech and Greek. Previous releases of SQL Server Full-Text Search did not include support for these two languages.

  • Korean. The word breaker and stemmer for the Korean language are not upgraded in this release.

For general information about word breakers and stemmers, see Configure and Manage Word Breakers and Stemmers for Search.

The instructions for reverting and restoring word breakers and stemmers depend on the language. The following table summarizes the 3 sets of actions that may be required to revert to the previous version of the components.

Current filePrevious fileNumber of affected languagesAction for filesAction for registry entries
NaturalLanguage6.dllNaturalLanguage6.dll34Obtain and install a previous version of NaturalLanguage6.dll, overwriting the current version of the file.No action required.

The registry keys and values have not changed for this release.
(Other file name)NaturalLanguage6.dll5Obtain and install a previous version of NaturalLanguage6.dll, overwriting the current version of the file.Change a set of registry entries to specify the previous version of the components.
(Other file name)(Other file name)6No action required.

 SQL Server 2016 setup copies both the current and the previous versions of the components to the Binn folder.
Change a set of registry entries to specify the previous version of the components.
System_CAPS_ICON_warning.jpg Warning


If you replace the current version of the file NaturalLanguage6.dll with a different version, then the behavior of all the languages that use this file is affected.

The files described in this topic are DLL files that are installed in the MSSQL\Binn folder for the SQL Server instance. The full path is typically the following path:

C:\Program Files\Microsoft SQL Server\<instance>\MSSQL\Binn

For the languages in the following table, the file name of both the current and previous word breaker is NaturalLanguage6.dll. To revert or restore these components, you have to overwrite NaturalLanguage6.dll with a different version of the same file. You do not have to change any registry entries, because the registry entries have not changed for this release.

System_CAPS_ICON_warning.jpg Warning


If you replace the current version of the file NaturalLanguage6.dll with a different version, then the behavior of all the languages that use this file is affected.

List of affected languages

LanguageAbbreviation
used in the
registry
LCID
Bengaliben1093
Bulgarianbgr1026
Catalancat1027
Spanishesn3082
Frenchfra1036
Gujaratiguj1095
Hebrewheb1037
Hindihin1081
Croatianhrv1050
Indonesianind1057
Icelandicisl1039
Italianita1040
Kannadakan1099
Lithuanianlth1063
Latvianlvi1062
Malayalammal1100
Marathimar1102
Malaymsl1086
NeutralNeutral0000
Norwegial Bokmaalnor1044
Punjabipan1094
Brazilian Portugueseptb1046
Portugueseptg2070
Romanianrom1048
Slovaksky1051
Slovenianslv1060
Serbian - Cyrillicsrb3098
Serbian - Latinsrl2074
Swedishsve1053
Tamiltam1097
Telugutel1098
Ukrainianukr1058
Urduurd1056
Vietnamesevit1066

The preceding table is sorted alphabetically on the Abbreviation column.

To revert to the previous components

  1. Navigate to the Binn folder described above.

  2. Back up the SQL Server 2016 version of NaturalLanguage6.dll to another location.

  3. Copy the previous version of NaturalLanguage6.dll from the Binn folder of an instance of SQL Server 2008 R2 or SQL Server 2008 into the Binn folder of the SQL Server 2016 instance.

    System_CAPS_ICON_warning.jpg Warning


    This change affects all the languages that use NaturalLanguage6.dll in both the current and previous version.

  4. Restart SQL Server.

To restore the current components

  1. Navigate to the location where you backed up the SQL Server 2016 version of NaturalLanguage6.dll.

  2. Copy the current version of NaturalLanguage6.dll from the backup location into the Binn folder of the SQL Server 2016 instance.

    System_CAPS_ICON_warning.jpg Warning


    This change affects all the languages that use NaturalLanguage6.dll in both the current and previous version.

  3. Restart SQL Server.

For the languages in the following table, the file name of the previous word breaker is different from the file name of the new version. The previous file name is NaturalLanguage6.dll. To revert to the previous version, you have to overwrite the current version of NaturalLanguage6.dll with an earlier version of the same file. You also have to change a set of registry entries to specify the previous or current version of the components.

System_CAPS_ICON_warning.jpg Warning


If you replace the current version of the file NaturalLanguage6.dll with a different version, then the behavior of all the languages that use this file is affected.

List of affected languages

LanguageAbbreviation
used in the
registry
LCID
Arabicara1025
Germandeu1031
Japanesejpn1041
Dutchnld1043
Russianrus1049

The preceding table is sorted alphabetically on the Abbreviation column.

Use the following instructions together with the list of values in the section File names and registry values for reverting and restoring word breakers and stemmers.

To revert to the previous components

  1. Navigate to the Binn folder described above.

  2. Do not remove the files for the current version of the components from the Binn folder.

  3. Back up the SQL Server 2016 version of NaturalLanguage6.dll to another location.

  4. Copy the previous version of NaturalLanguage6.dll from the Binn folder of an instance of SQL Server 2008 R2 or SQL Server 2008 into the Binn folder of the SQL Server 2016 instance.

    System_CAPS_ICON_warning.jpg Warning


    This change affects all the languages that use NaturalLanguage6.dll in both the current and previous version.

  5. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\CLSID.

  6. Use the following steps to add new keys for the COM ClassIDs for the previous word breaker and stemmer interfaces for the selected language:

    1. Add a new key with the value from the table for the previous word breaker.

    2. Update the (Default) data of that key value to the file name of the previous word breaker from the table.

    3. If the selected language uses a stemmer, then add a new key with the value from the table for the previous stemmer.

    4. If the selected language uses a stemmer, then update the (Default) data of that key value to the file name of the previous stemmer from the table.

  7. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\<language_key>. <language_key> represents the abbreviation for the language that is used in the registry; for example, "fra" for French and "esn" for Spanish.

  8. Update the WBreakerClass key value to the value from the table for the current word breaker.

  9. If the selected language uses a stemmer, then update the StemmerClass key value to the value from the table for the current stemmer.

  10. Restart SQL Server.

To restore the current components

  1. Navigate to the location where you backed up the SQL Server 2016 version of NaturalLanguage6.dll.

  2. Copy the current version of NaturalLanguage6.dll from the backup location into the Binn folder of the SQL Server 2016 instance.

    System_CAPS_ICON_warning.jpg Warning


    This change affects all the languages that use NaturalLanguage6.dll in both the current and previous version.

  3. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\CLSID.

  4. If the following keys do not exist, then use the following steps to add new keys for the COM ClassIDs for the current word breaker and stemmer interfaces for the selected language:

    1. Add a new key with the value from the table for the current word breaker.

    2. Update the (Default) data of that key value to the file name of the current word breaker from the table.

    3. If the selected language uses a stemmer, then add a new key with the value from the table for the current stemmer.

    4. If the selected language uses a stemmer, then update the (Default) data of that key value to the file name of the current stemmer from the table.

  5. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\<language_key>. <language_key> represents the abbreviation for the language that is used in the registry; for example, "fra" for French and "esn" for Spanish.

  6. Update the WBreakerClass key value to the value from the table for the previous word breaker.

  7. If the selected language uses a stemmer, then update the StemmerClass key value to the value from the table for the previous stemmer.

  8. Restart SQL Server.

File names and registry values for reverting and restoring word breakers and stemmers

Use the following list of file names and registry entries together with the instructions in the preceding section. Use the previous values to revert to the previous version, or use the current values to restore the current version of the components.

The following listed is sorted alphabetically on the abbreviation used for each language.

Arabic (ara), LCID 1025

ComponentWord breakerStemmer
Previous CLSID7EFD3C7E-9E4B-4a93-9503-DECD74C0AC6D483B0283-25DB-4c92-9C15-A65925CB95CE
Previous file nameNaturalLanguage6.dllNaturalLanguage6.dll
Current CLSID04b37e30-c9a9-4a7d-8f20-792fc87ddf71None
Current file nameMSWB7.dllNone

German (deu), LCID 1031

ComponentWord breakerStemmer
Previous CLSID45EACA36-DBE9-4e4a-A26D-5C201902346D65170AE4-0AD2-4fa5-B3BA-7CD73E2DA825
Previous file nameNaturalLanguage6.dllNaturalLanguage6.dll
Current CLSIDdfa00c33-bf19-482e-a791-3c785b0149b48a474d89-6e2f-419c-8dd5-9b50edc8c787
Current file nameMsWb7.dllMsWb7.dll

Japanese (jpn), LCID 1041

ComponentWord breakerStemmer
Previous CLSIDE1E8F15E-8BEC-45df-83BF-50FF84D0CAB53D5DF14F-649F-4cbc-853D-F18FEDE9CF5D
Previous file nameNaturalLanguage6.dllNaturalLanguage6.dll
Current CLSID04096682-6ece-4e9e-90c1-52d81f0422edNone
Current file nameMsWb70011.dllNone

Dutch (nld), LCID 1043

ComponentWord breakerStemmer
Previous CLSID2C9F6BEB-C5B0-42b6-A5EE-84C24DC0D8EFF7A465EE-13FB-409a-B878-195B420433AF
Previous file nameNaturalLanguage6.dllNaturalLanguage6.dll
Current CLSID69483c30-a9af-4552-8f84-a0796ad5285bCF923CB5-1187-43ab-B053-3E44BED65FFA
Current file nameMsWb7.dllMsWb7.dll

Russian (rus), LCID 1049

ComponentWord breakerStemmer
Previous CLSID2CB6CDA4-1C14-4392-A8EC-81EEF1F2E079E06A0DDD-E81A-4e93-8A8D-F386C3A1B670
Previous file nameNaturalLanguage6.dllNaturalLanguage6.dll
Current CLSIDaaa3d3bd-6de7-4317-91a0-d25e7d3babc3d42c8b70-adeb-4b81-a52f-c09f24f77dfa
Current file nameMsWb7.dllMsWb7.dll

For the languages in the following table, the file names of the previous word breakers and stemmers are different from the file names of the new versions. Neither the previous nor the current file name is NaturalLanguage6.dll. You do not have to replace any files, because SQL Server 2016 setup copies both the current and the previous versions of the components to the Binn folder. However you have to change a set of registry entries to specify the previous or current version of the components.

List of affected languages

LanguageAbbreviation
used in the
registry
LCID
Simplified Chinesechs2052
Traditional Chinesecht1028
Thaitha1054
Chinese Traditionalzh-hk3076
Chinese Traditionalzh-mo5124
Chinese Simplifiedzh-sg4100

The preceding table is sorted alphabetically on the Abbreviation column.

Use the following instructions together with the list of values in the section File names and registry values for reverting and restoring word breakers and stemmers.

To revert to the previous components

  1. Do not remove the files for the current version of the components from the Binn folder.

  2. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\CLSID.

  3. Use the following steps to add new keys for the COM ClassIDs for the previous word breaker and stemmer interfaces for the selected language:

    1. Add a new key with the value from the table for the previous word breaker.

    2. Update the (Default) data of that key value to the file name of the previous word breaker from the table.

    3. If the selected language uses a stemmer, then add a new key with the value from the table for the previous stemmer.

    4. If the selected language uses a stemmer, then update the (Default) data of that key value to the file name of the previous stemmer from the table.

  4. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\<language_key>. <language_key> represents the abbreviation for the language that is used in the registry; for example, "fra" for French and "esn" for Spanish.

  5. Update the WBreakerClass key value to the value from the table for the current word breaker.

  6. If the selected language uses a stemmer, then update the StemmerClass key value to the value from the table for the current stemmer.

  7. Restart SQL Server.

To restore the previous components

  1. Do not remove the files for the previous version of the components from the Binn folder.

  2. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\CLSID.

  3. If the following keys do not exist, then use the following steps to add new keys for the COM ClassIDs for the current word breaker and stemmer interfaces for the selected language:

    1. Add a new key with the value from the table for the current word breaker.

    2. Update the (Default) data of that key value to the file name of the current word breaker from the table.

    3. If the selected language uses a stemmer, then add a new key with the value from the table for the current stemmer.

    4. If the selected language uses a stemmer, then update the (Default) data of that key value to the file name of the current stemmer from the table.

  4. In the registry, navigate to the following node: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\<language_key>. <language_key> represents the abbreviation for the language that is used in the registry; for example, "fra" for French and "esn" for Spanish.

  5. Update the WBreakerClass key value to the value from the table for the previous word breaker.

  6. If the selected language uses a stemmer, then update the StemmerClass key value to the value from the table for the previous stemmer.

  7. Restart SQL Server.

File names and registry values for reverting and restoring word breakers and stemmers

Use the following list of file names and registry entries together with the instructions in the preceding section. Use the previous values to revert to the previous version, or use the current values to restore the current version of the components.

The following listed is sorted alphabetically on the abbreviation used for each language.

Simplified Chinese (chs), LCID 2052

ComponentWord breaker
Previous CLSID12CE94A0-DEFB-11D2-B31D-00600893A857
Previous file namechsbrkr.dll
Current CLSIDE0831C90-BAB0-4ca5-B9BD-EA254B538DAC
Current file nameMsWb70804.dll

Traditional Chinese (cht), LCID 1028

ComponentWord breaker
Previous CLSID1680E7C3-9430-4A51-9B82-1E7E7AEE5258
Previous file namechtbrkr.dll
Current CLSIDE9B1DF65-08F1-438b-8277-EF462B23A792
Current file nameMsWb70404.dll

Thai (tha), LCID 1054

ComponentWord breakerStemmer
Previous CLSIDCCA22CF4-59FE-11D1-BBFF-00C04FB97FDACEDC01C7-59FE-11D1-BBFF-00C04FB97FDA
Previous file nameThawbrkr.dllThawbrkr.dll
Current CLSIDF70C0935-6E9F-4ef1-9F06-7876536DB900None
Current file nameMsWb7001e.dllNone

Chinese Traditional (zh-hk), LCID 3076

ComponentWord breaker
Previous CLSID1680E7C3-9430-4A51-9B82-1E7E7AEE5258
Previous file namechtbrkr.dll
Current CLSIDE9B1DF65-08F1-438b-8277-EF462B23A792
Current file nameMsWb70404.dll

Chinese Traditional (zh-mo), LCID 5124

ComponentWord breaker
Previous CLSID1680E7C3-9430-4A51-9B82-1E7E7AEE5258
Previous file namechtbrkr.dll
Current CLSIDE9B1DF65-08F1-438b-8277-EF462B23A792
Current file nameMsWb70404.dll

Chinese Simplified (zh-sg), LCID 4100

ComponentWord breaker
Previous CLSID12CE94A0-DEFB-11D2-B31D-00600893A857
Previous file namechsbrkr.dll
Current CLSIDE0831C90-BAB0-4ca5-B9BD-EA254B538DAC
Current file nameMsWb70804.dll

Change the Word Breaker Used for US English and UK English
Behavior Changes to Full-Text Search

Community Additions

ADD
Show: