ADOdb - v5:reference

$ADODB_ANSI_PADDING_OFF

Anonymous (anonymous@undisclosed.example.com) — 2016-01-13T01:30:09+00:00

$ADODB_ANSI_PADDING_OFF TypeBooleanDefaultFalseDriver SupportLimited Determines whether to right trim CHAR fields (and also VARCHAR for ibase/firebird). Set to true to trim. Default is false. Currently works for the following drivers: * oci8po *

ADODB_ASSOC_CASE

Anonymous (anonymous@undisclosed.example.com) — 2022-06-08T14:14:25+00:00

ADODB_ASSOC_CASE When returning data in associative fetch mode, the ADODB_ASSOC_CASE constant gives control over the casing of the retrieved recordsets' fields. It must be declared before initializing the database connection with ADONewConnection(). Being a constant, it is of course not possible to change its value later on.

$ADODB_CACHE_CLASS

Anonymous (anonymous@undisclosed.example.com) — 2025-06-01T11:21:15+00:00

$ADODB_CACHE_CLASS Description If recordset caching is used, then only a single method of caching can be used at any one time, for example, if a MemCached Server is used, then physical disk caching can not be used simultaneously. The handle to the caching class is stored in the

$ADODB_CACHE_DIR

Anonymous (anonymous@undisclosed.example.com) — 2016-03-20T01:43:25+00:00

$ADODB_CACHE_DIR TypeStringDefaultempty Description If you are using recordset caching, this is the directory to save your recordsets in. There is no default definition . Define this before you call any caching functions such as cacheExecute. If using this feature with PHP versions less than 5.4 we recommend setting

$ADODB_COMPAT_FETCH

Anonymous (anonymous@undisclosed.example.com) — 2021-12-18T20:02:02+00:00

$ADODB_COMPAT_FETCH Definition TypeIntegerDefault0 This is a global variable that determines the behavior of a fetched record if the pointer is advanced beyond the boundaries of a recordset. By default, if the pointer moves beyond EOF, then the record in the buffer is set to false. If the

$ADODB_COUNTRECS

Anonymous (anonymous@undisclosed.example.com) — 2025-07-27T00:38:53+00:00

$ADODB_COUNTRECS TypeBooleanDefaultTrue See Also po_recordCount If a driver has native support for returning the number of records returned in an SELECT statement, then recordCount will automatically return the number of rows requested in the query. In drivers that have no native support, then the result can be emulated by setting

ADODB_DEFAULT_METATYPE

Anonymous (anonymous@undisclosed.example.com) — 2023-11-05T00:17:01+00:00

ADODB_DEFAULT_METATYPE The constant must be declared before including adodb.inc.php. It is not possible to change the default metatype during a procedure. The constant ADODB_DEFAULT_METATYPE controls the returned metatype of an unknown field type . The default value for this constant is 'N'.

$ADODB_FETCH_MODE

Anonymous (anonymous@undisclosed.example.com) — 2016-01-17T23:44:30+00:00

$ADODB_FETCH_MODE See Also setFetchMode Definition TypeIntegerDefault0 This is a global variable that determines how the keys of recordsets are presented when recordsets are retrived from the database. The recordset saves this value on creation (eg. in execute or

$ADODB_FORCE_TYPE

Anonymous (anonymous@undisclosed.example.com) — 2016-02-28T00:53:46+00:00

$ADODB_FORCE_TYPE The behaviour of autoExecute(), getUpdateSql() and getInsertSql() when converting empty or null PHP variables to SQL is controlled by the global $ADODB_FORCE_TYPE variable. The default value is ADODB_FORCE_VALUE Constants Constant Value Description

$ADODB_GETONE_EOF

Anonymous (anonymous@undisclosed.example.com) — 2023-06-19T13:27:14+00:00

$ADODB_GETONE_EOF TypemixedDefaultnull This is a global variable that determines what the getOne() method returns if the SQL statement fails to match any records in a recordset. The value can be set or reset at any point in a script. If the value that is being retrieved can return an empty or 0 value, it is important to do an exact comparison on the returned value to distinguish between queries where the value of the record found is empty and queries where no record is found

$ADODB_LANG

Anonymous (anonymous@undisclosed.example.com) — 2024-08-25T23:02:38+00:00

$ADODB_LANG Most of the language files have been provided by users of ADOdb. If you can, help by providing new or improved language files TypeStringDefaulten Description Determines the language used in metaErrorMsg. The default is 'en', for US English. The following language codes are supported:

$ADODB_QUOTE_FIELDNAMES

Anonymous (anonymous@undisclosed.example.com) — 2022-06-09T08:05:24+00:00

$ADODB_QUOTE_FIELDNAMES The behavior of field name quoting will change in ADOdb Version 6 This global variable controls quoting and casing of field names when the autoExecute() method is used. The default behavior of autoExecute is to quote field names, and convert them to upper case.

Reference Manual

Anonymous (anonymous@undisclosed.example.com) — 2016-01-16T22:02:05+00:00

Reference Manual

Connection Ref…

Logging

Anonymous (anonymous@undisclosed.example.com) — 2024-01-09T10:14:33+00:00
Logging ADOdb provides an internal debugging system that exposes the executed SQL commands, as well as other messages that can help when troubleshooting errors when, for example, trying to establish a connection to the database or an SQL statement fails.

Reference Manual

Anonymous (anonymous@undisclosed.example.com) — 2026-02-23T01:55:47+00:00
Reference Manual Reference Manual See the Feature Comparison Matrix Variables $ADODB_COUNTRECS In database drivers that do not support native recordset counting, controls whether to emulate the functionality $ADODB_ANSI_PADDING_OFF Determines whether to right trim CHAR fields