ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:setconnectionparameter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
v5:reference:connection:setconnectionparameter [2022/03/24 18:08] – mnewnhamv5:reference:connection:setconnectionparameter [2022/07/13 03:27] – [IDM DB2] mnewnham
Line 22: Line 22:
 $db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4'); $db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
 $db->connect('hostname', 'user', 'password', 'database'); $db->connect('hostname', 'user', 'password', 'database');
 +</code>
 +
 +
 +=== Workaround for setting Server side character set on MySQL ===
 +<code php>
 +$SQL = "SET 
 +    character_set_results    = 'utf8mb4',
 +    character_set_client     = 'utf8mb4', 
 +    character_set_connection = 'utf8mb4',
 +    character_set_database   = 'utf8mb4', 
 +    character_set_server     = 'utf8mb4'";
 +$db->execute($SQL);
 </code> </code>
 ==== Firebird ==== ==== Firebird ====
Line 37: Line 49:
 ==== Oracle ==== ==== Oracle ====
 //$parameterName// must be one of the following //$parameterName// must be one of the following
 +
 === session_mode === === session_mode ===
 +
 Sets the Oracle Session Mode. The default value is ''OCI_DEFAULT''. Other values are: Sets the Oracle Session Mode. The default value is ''OCI_DEFAULT''. Other values are:
   * ''OCI_CRED_EXT''    * ''OCI_CRED_EXT'' 
   * ''OCI_SYSOPER''    * ''OCI_SYSOPER'' 
   * ''OCI_SYSDBA''   * ''OCI_SYSDBA''
 +
 <code php> <code php>
 $db = ADONewConnection('oci8'); $db = ADONewConnection('oci8');
Line 47: Line 62:
 $db->connect($database,$user,$password); $db->connect($database,$user,$password);
 </code> </code>
 +
 === client_identifier === === client_identifier ===
-Sets the [[https://www.php.net/manual/en/function.oci-set-client-identifier.php|Oracle Client Identifier]]+(ADOdb >= 5.21.3) 
 + 
 +Sets the [[https://www.php.net/manual/en/function.oci-set-client-identifier.php|Oracle Client Identifier]]. 
 <code php> <code php>
 $db = ADONewConnection('oci8'); $db = ADONewConnection('oci8');
Line 58: Line 77:
  
  
-===== Other Usage ===== +==== SQL Server ==== 
-<code php> +Parameters must be set from the list of Microsoft [[https://docs.microsoft.com/en-us/sql/connect/php/connection-options|PHP Connection Options]]
  
 +<code php>
 /* /*
- * Connecting to DB2 Database+ * Example setting the character set
  */  */
-$db->setConnectionParameter('autocommit',DB2_AUTOCOMMIT_ON);+$db->setConnectionParameter('CharacterSet','UTF-8');
 $db->connect('database','user','password'); $db->connect('database','user','password');
 +</code>
  
 +==== IDM DB2 ====
 +<code php>
 /* /*
- * Connecting to a SQL Server database+ * Connecting to DB2 Database
  */  */
-$db->setConnectionParameter('CharacterSet','UTF-8');+$db->setConnectionParameter('autocommit',DB2_AUTOCOMMIT_ON);
 $db->connect('database','user','password'); $db->connect('database','user','password');
 </code> </code>
  
v5/reference/connection/setconnectionparameter.txt · Last modified: 2022/07/13 03:47 by mnewnham