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 [2019/11/12 11:24] – [setConnectionParameter] dregad | v5:reference:connection:setconnectionparameter [2022/07/13 03:47] (current) – [IDM DB2] mnewnham | ||
---|---|---|---|
Line 12: | Line 12: | ||
The function '' | The function '' | ||
- | If used in a portable environment, | + | If used in a portable environment, |
- | ===== Usage ===== | + | |
+ | ===== Database Specific Values | ||
+ | ==== MySQL ==== | ||
+ | // | ||
+ | <code php> | ||
+ | |||
+ | $db = ADONewConnection(' | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | |||
+ | === Workaround for setting Server side character set on MySQL === | ||
+ | <code php> | ||
+ | $SQL = "SET | ||
+ | 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> | <code php> | ||
/* | /* | ||
- | | + | |
*/ | */ | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | ==== IDM DB2 ==== | ||
+ | Parameters must be chosen from the list of DB2 [[https:// | ||
+ | <code php> | ||
+ | /* | ||
+ | * Example Setting Auto-commit | ||
+ | */ | ||
$db-> | $db-> | ||
$db-> | $db-> | ||
+ | </ | ||
+ | ==== PDO Driver ==== | ||
+ | Any parameter from the PHP [[https:// | ||
+ | <code php> | ||
/* | /* | ||
- | * Connecting to a SQL Server database | + | * Example Setting Timeout Duration |
- | */ | + | */ |
- | $db-> | + | $db-> |
- | $db-> | + | $db-> |
</ | </ |
v5/reference/connection/setconnectionparameter.1573554254.txt.gz · Last modified: 2019/11/12 11:24 by dregad