fox-manager-2.0-bpa:1.-общая-информация:тонкие-настройки-подключения-к-базе-данных
Различия
Показаны различия между двумя версиями страницы.
| Предыдущая версия справа и слеваПредыдущая версияСледующая версия | Предыдущая версияСледующая версияСледующая версия справа и слева | ||
| fox-manager-2.0-bpa:1.-общая-информация:тонкие-настройки-подключения-к-базе-данных [2020/06/10 23:23] – erazor | fox-manager-2.0-bpa:1.-общая-информация:тонкие-настройки-подключения-к-базе-данных [2020/06/10 23:31] – [Список доступных настроек] erazor | ||
|---|---|---|---|
| Строка 181: | Строка 181: | ||
| |SSLKey|The pathname to the key file.| | |SSLKey|The pathname to the key file.| | ||
| |SSLMode|This option determines whether or with what priority an SSL connection will be negotiated with the server. Supported values: **smAllow** Negotiates trying first a non-SSL connection, then if that fails, tries an SSL connection. **smDisable** (default) Only an unencrypted SSL connection will be attempted. **smPrefer** Negotiates trying first an SSL connection, then if that fails, tries a regular non-SSL connection. **smRequire** Tries only an SSL connection. **smVerifyCA** Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine. **smVerifyFull** Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine and validates that the server hostname matches the server certificate. Note: If PostgreSQL is compiled without SSL support, using option smRequire will cause an error, while options smAllow and smPrefer will be accepted, but PgDAC will not in fact attempt an SSL connection.| | |SSLMode|This option determines whether or with what priority an SSL connection will be negotiated with the server. Supported values: **smAllow** Negotiates trying first a non-SSL connection, then if that fails, tries an SSL connection. **smDisable** (default) Only an unencrypted SSL connection will be attempted. **smPrefer** Negotiates trying first an SSL connection, then if that fails, tries a regular non-SSL connection. **smRequire** Tries only an SSL connection. **smVerifyCA** Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine. **smVerifyFull** Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine and validates that the server hostname matches the server certificate. Note: If PostgreSQL is compiled without SSL support, using option smRequire will cause an error, while options smAllow and smPrefer will be accepted, but PgDAC will not in fact attempt an SSL connection.| | ||
| + | |UseHttp|The UseHttp option enables the use of HTTP tunneling to connect to the server. The default value is False.| | ||
| + | |UuidWithBraces|Use the UuidWithBraces option to specify whether the values of UUID fields are returned with braces. The default value is True.| | ||
| |UseUnicode|Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, | |UseUnicode|Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, | ||
| Строка 199: | Строка 201: | ||
| |ReadUncommitted|Enables or disables Read-Uncommitted isolation mode. A database connection in read-uncommitted mode does not attempt to obtain read-locks before reading from database tables as described above. This can lead to inconsistent query results if another database connection modifies a table while it is being read, but it also means that a read-transaction opened by a connection in read-uncommitted mode can neither block nor be blocked by any other connection. Default value of this option is False. | |ReadUncommitted|Enables or disables Read-Uncommitted isolation mode. A database connection in read-uncommitted mode does not attempt to obtain read-locks before reading from database tables as described above. This can lead to inconsistent query results if another database connection modifies a table while it is being read, but it also means that a read-transaction opened by a connection in read-uncommitted mode can neither block nor be blocked by any other connection. Default value of this option is False. | ||
| |TimeFormat|Defines the format for storing time in the database. If it is not specified, the default hh24:mi:ss format will be used. | | |TimeFormat|Defines the format for storing time in the database. If it is not specified, the default hh24:mi:ss format will be used. | | ||
| + | |CipherLicense|To use the SQLCipher Commercial Edition library for encrypting SQLite database files, insert your SQLCipher license key into the field. Note that the option is not available in Direct mode.| | ||
| + | |ConnectMode|Specifies which user privileges to use when accessing a SQLite database. Supported values: **cmDefault** (default) Connect with default permissions. **cmReadWrite** Connect with read/write permissions. **cmReadOnly** Connect with read-only permissions.| | ||
| + | |NativeDate|If the option is set to True, the date and time values will be stored in the database in the native SQLite format, and when retrieved, they will be converted to the TDateTime type. If set to False, no conversion to the TDateTime type will be made. The default value is True.| | ||
| |UseUnicode|Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, | |UseUnicode|Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, | ||
fox-manager-2.0-bpa/1.-общая-информация/тонкие-настройки-подключения-к-базе-данных.txt · Последнее изменение: 2024/05/12 19:35 — 127.0.0.1