PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Search performed on an "accent-sensitive" item
  • Configuring the different search options for an item
  • Limits
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
AccentuationSensitive (Property)
In french: SensibleAccentuation
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
AccentuationSensitive is used to configure the management mode of accented characters in the different searches performed on the item or on the full-text index (with HReadSeek, HReadSeekFirst and HReadSeekLast for example). You can:
  • Find out whether the accented characters are taken into account in the searches performed on this item (or on this full-text index). The item or the full-text index have been defined in the data model editor or by programming.
  • Define the management of accented characters for an item or for a full-text index (when the item or the full-text index is described by programming).
Versions 17 and later
iPhone/iPad This property is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone and iPad applications.
iPhone/iPad This property is now available for the iPhone and iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App This property is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Define how the accented characters are managed in Orders.Name
Name..AccentuationSensitive = True
...
// Validates the description of data file
HDescribeFile(Orders)
Syntax

Finding out whether the accented characters are taken into account Hide the details

<Result> = <Data file>.<Item>..AccentuationSensitive
<Result>: Boolean
  • True if the accented characters are taken into account by the searches performed on this item,
  • False otherwise.
<Data file>: Character string (with or without quotes)
Name of data file used. This name was defined in the data model editor or by the File description type.
<Item>: Character string (with or without quotes)
  • Name of item used. This name was defined in the data model editor or by the Item description type.
  • Name of full-text index used. This name was defined in the data model editor or by the FullTextIndex description type.

Defining the management mode of accented characters (item described by programming) Hide the details

<Item>..AccentuationSensitive = <New management mode>
<Item>: Character string (with or without quotes)
<New management mode>: Boolean
  • True if the accented characters must be taken into account by the searches performed on this item,
  • False otherwise.
Remarks

Search performed on an "accent-sensitive" item

When a search is performed on an "accent-sensitive" item, only the words with matching accented characters will be found. Therefore, if the customer name is "Renée", the search performed on:
  • "Renée" will find the record,
  • "Renee" will not find the record.

Configuring the different search options for an item

  • To manage the accented characters during the searches, use ..AccentuationSensitive.
  • To manage the case during the searches, use ..CaseSensitive.
  • To manage the punctuation during the searches, use ..PunctuationSensitive.

Limits

..AccentuationSensitive must not be used on a Numeric item or on a composite key. Otherwise, an incorrect result may be returned.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment