ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Stemming (Property)
In french: Racinisation
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
The Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming.
The stemming is used to perform searches on a full-text index while taking the variations of a given word into account. This feature is not interesting for the knowledge databases and it allows you fo indifferently find words in singular or plural form.
Example
MyFullTextIndex is FullTextIndex Description
...
MyFullTextIndex.Stemming = nationEnglish
Syntax
<Full-text index>.Stemming = <Language>
<Full-text index>: Character string
Name of full-text index used. This name was defined by the FullTextIndex Description type.
<Language>: Integer constant
Language for stemming:
ConstantLanguage
nationGerman
German
nationEnglish
English
nationDanish
Danish
nationSpanish
Spanish
nationFinnish
Finnish
nationFrench
French
nationHungarian
Hungarian
nationItalian
Italian
nationDutch
Dutch
nationNorwegian
Norwegian
nationPortuguese
Portuguese
nationRomanian
Romanian
nationRussian
Russian
nationSwedish
Swedish
nationTurkish
Turkish
Remarks
  • The management of synonyms (Synonym) must not be enabled if the stemming is enabled.
  • The management of accented characters (AccentSensitive) must be enabled if the stemming is enabled.
  • Because of grammatical exceptions (irregular verbs in English, verbs of third group in French, etc.), some conjugations may not be grouped together (for example, a search for "fly" will not found the records containing "flown") or some plural forms may not be grouped with their singular form (foot/feet for example).
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help