PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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 (Property)
In french: Racinisation
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
The Property Racinization allows to activate the rootization and to define the language used to perform a rootization in a programming defined full-text index.
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
...
MonIndexFulText.Racinisation = nationFrench
Syntax
<Full-text index>.Stemming = <Language>
<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, 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