TMyConnection.Options Property

Specifies the behaviour of TMyConnection object.




property Options: TMyConnectionOptions;


Set the properties of Options to specify the behaviour of a TMyConnection object.

Descriptions of all options are in the table below.

Option Name Description
Charset Used to set the character set that MyDAC uses to read and write character data.
CheckBackslashes Used to check the value of the NO_BACKSLASH_ESCAPES server variable.
Compress Used to apply compression on transferring data.
DefaultSortType Used to determine the default type of local sorting for string fields. It is used when a sort type is not specified explicitly after the field name in the TMemDataSet.IndexFieldNames property of a dataset.
Direct Used to work without using MySQL client library (libmysql.dll).
DisconnectedMode Used to open a connection only when needed for performing a server call and closes after performing the operation.
Embedded Used to specify the server that will be used to connect.
Interactive Permit interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable is set to the value of the session interactive_timeout variable.
IPVersion Used to specify Internet Protocol Version.
KeepDesignConnected Used to prevent an application from establishing a connection at startup.
LocalFailover If True, the TCustomDAConnection.OnConnectionLost event occurs and a failover operation can be performed after connection breaks.
NullForZeroDelphiDate Used to hide the '30-12-1899' dates.
NumericType Specifies the format of storing and representing NUMERIC (DECIMAL) fields.
OptimizedBigInt Used to convert all fields with field length less than 11 of TLargeIntField type into TIntegerField.
Protocol Used to specify the protocol to use when connecting to server.
UseUnicode Used to specify whether the UTF8 charset will be used.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback