Specifies the behaviour of TMyConnection object.
Class
TMyConnection
Syntax
property Options: TMyConnectionOptions;
Remarks
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