v5:reference:connection:setconnectionparameter
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:reference:connection:setconnectionparameter [2022/03/24 17:42] – mnewnham | v5:reference:connection:setconnectionparameter [2022/07/13 03:47] (current) – [IDM DB2] mnewnham | ||
---|---|---|---|
Line 17: | Line 17: | ||
==== MySQL ==== | ==== MySQL ==== | ||
// | // | ||
+ | <code php> | ||
+ | |||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | |||
+ | === Workaround for setting Server side character set on MySQL === | ||
+ | <code php> | ||
+ | $SQL = " | ||
+ | character_set_results | ||
+ | character_set_client | ||
+ | character_set_connection = ' | ||
+ | character_set_database | ||
+ | character_set_server | ||
+ | $db-> | ||
+ | </ | ||
==== Firebird ==== | ==== Firebird ==== | ||
- | // | + | // |
* role | * role | ||
* dialect | * dialect | ||
* buffers | * buffers | ||
+ | |||
+ | <code php> | ||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
==== Oracle ==== | ==== Oracle ==== | ||
- | // | + | // |
=== session_mode === | === session_mode === | ||
+ | |||
Sets the Oracle Session Mode. The default value is '' | Sets the Oracle Session Mode. The default value is '' | ||
* '' | * '' | ||
* '' | * '' | ||
* '' | * '' | ||
+ | |||
<code php> | <code php> | ||
+ | $db = ADONewConnection(' | ||
$db-> | $db-> | ||
$db-> | $db-> | ||
</ | </ | ||
+ | === client_identifier === | ||
+ | (ADOdb >= 5.21.3) | ||
+ | Sets the [[https:// | ||
+ | <code php> | ||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
- | ===== Usage ===== | + | |
+ | |||
+ | ==== SQL Server | ||
+ | Parameters must be set from the list of Microsoft [[https:// | ||
<code php> | <code php> | ||
/* | /* | ||
- | | + | |
*/ | */ | ||
- | $db = ADONewConnection(' | + | $db-> |
- | $db-> | + | $db-> |
- | $db-> | + | </ |
+ | ==== IDM DB2 ==== | ||
+ | Parameters must be chosen from the list of DB2 [[https:// | ||
+ | <code php> | ||
/* | /* | ||
- | | + | |
*/ | */ | ||
$db-> | $db-> | ||
$db-> | $db-> | ||
+ | </ | ||
+ | ==== PDO Driver ==== | ||
+ | Any parameter from the PHP [[https:// | ||
+ | |||
+ | <code php> | ||
/* | /* | ||
- | | + | |
*/ | */ | ||
- | $db-> | + | $db-> |
- | $db-> | + | $db-> |
</ | </ | ||
- |
v5/reference/connection/setconnectionparameter.1648140121.txt.gz · Last modified: 2022/03/24 17:42 by mnewnham