ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
AccentSensitive (Property)
In french: SensibleAccentuation
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Warning
From version 27, AccentuationSensitive is kept for backward compatibility. This property has been replaced with AccentSensitive.
The AccentSensitive property is used to determine if accented characters are taken into account in the different searches performed on the item or 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 has been defined in the data model editor or through 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 through programming).
Example
// Define how the accented characters are managed in Orders.Name
Name.AccentSensitive = True
...
// Validate the data file description
HDescribeFile(Orders)
Syntax

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

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

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

<Item>.AccentSensitive = <New mode>
<Item>: Character string
<New 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 make searches accent-sensitive or insensitive, use the AccentSensitive property.
  • To make searches case-sensitive or insensitive, use the CaseSensitive property.
  • To make searches punctuation-sensitive or insensitive, use the PunctuationSensitive property.

Limits

The AccentSensitive property 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

Last update: 02/29/2024

Send a report | Local help