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 [2021/03/10 11:50] – Document need to use predefined constants for mysqli and add example dregad | v5:reference:connection:setconnectionparameter [2022/07/13 03:47] (current) – [IDM DB2] mnewnham | ||
---|---|---|---|
Line 14: | Line 14: | ||
If used in a portable environment, | If used in a portable environment, | ||
- | On MySQL, // | + | ===== Database Specific Values ===== |
- | + | ==== MySQL ==== | |
- | + | // | |
- | ===== Usage ===== | + | |
<code php> | <code php> | ||
- | /* | + | |
- | * Connecting to a MySQL database | + | |
- | */ | + | |
$db = ADONewConnection(' | $db = ADONewConnection(' | ||
$db-> | $db-> | ||
$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 ==== | ||
+ | // | ||
+ | * role | ||
+ | * dialect | ||
+ | * buffers | ||
+ | |||
+ | <code php> | ||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | ==== Oracle ==== | ||
+ | // | ||
+ | |||
+ | === session_mode === | ||
+ | |||
+ | Sets the Oracle Session Mode. The default value is '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '' | ||
+ | |||
+ | <code php> | ||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | === client_identifier === | ||
+ | (ADOdb >= 5.21.3) | ||
+ | |||
+ | Sets the [[https:// | ||
+ | |||
+ | <code php> | ||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==== SQL Server ==== | ||
+ | Parameters must be set from the list of Microsoft [[https:// | ||
+ | |||
+ | <code php> | ||
/* | /* | ||
- | | + | |
*/ | */ | ||
- | $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> | ||
+ | /* | ||
+ | * Example Setting Timeout Duration | ||
+ | */ | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ |
v5/reference/connection/setconnectionparameter.txt · Last modified: 2022/07/13 03:47 by mnewnham