PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

Stemming (Property)
In french: Racinisation
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..Stemming is used to enable the stemming and to define the language used to perform a stemming in a full-text index defined by 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
<Name of Full-Text Index>..Stemming = <Language>
<Name of Full-Text Index>: Character string (with or without quotes)
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 (..AccentuationSensitive) must be enabled if the stemming is enabled.
  • Because of grammatical exceptions (irregular verbs in English, verbs of third group in French, ...), 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