ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 programmatically.
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 of no interest for knowledge bases, and allows you to search indifferently for words in the singular or plural.
Example
MonIndexFulText is IndexFullText Description
...
MonIndexFulText.Stemming = nationFrench
Syntax
<Full-text index>.Stemming = <Language>
<Full-text index>: Character string
Name of full-text index used. This name is defined with 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/13/2025

Send a report | Local help