Since v2.7.4
Returns or sets common properties for all datasets (tables, queries, stored procedures) attached to this TMySQLDatabase component.
Syntax:
TMySQLDatasetOption = (mdsoZeroDateAsNull, mdsoFTStringAsVarchar, mdsoCaseInsensitiveLocalSort);
TMySQLDatasetOptions = set of TMySQLDatasetOption;
property DatasetOptions: TMySQLDatasetOptions;
Description:
Set DatasetOptions to adjust behavior of all TMySQLDataset descendants attached to this TMySQLDatabase component. DatasetOptions is a set drawn from the following values:
mdsoZeroDateAsNull
Enables treating zero date values (like "0000-00-00" or "0000-00-00 00:00:00") as Null values when opening dataset.
mdsoFTStringAsVarchar
When this option is set TMySQLTable.CreateTable method will create VARCHAR columns for ftString fields. And if this option is not set TMySQLTable.CreateTable method will create CHAR columns for ftString fields.
mdsoCaseInsensitiveLocalSort (since v2.7.6)
When this option is set TMySQLDataset descendants use case-insensitive sorting when using SortBy method or SortFieldNames property. If this option is not set simple binary comparing is performed for strings.
See also: TMySQLTable.CreateTable, TMySQLDataset.SortBy methods, TMySQLDataset.SortFieldNames property