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