Differences

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

--- v5:reference:connection:setconnectionparameter [2022/03/28 17:30] – [Oracle] client_identifier available since 5.23.0 dregad
+++ v5:reference:connection:setconnectionparameter [2022/07/13 03:47] (current) – [IDM DB2] mnewnham
@@ Line 22: / Line 22: @@
 $db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
 $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>
 ==== Firebird ====
@@ Line 52: / Line 64: @@
 === client_identifier ===
-(ADOdb >= 5.23.0)
+(ADOdb >= 5.21.3)
 Sets the [[https://www.php.net/manual/en/function.oci-set-client-identifier.php|Oracle Client Identifier]].
@@ Line 65: / 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');
+</code>
+==== IDM DB2 ====
+Parameters must be chosen from the list of DB2 [[https://www.php.net/manual/en/function.db2-connect|Connection Parameters]]
+<code php>
 /*
- * Connecting to a SQL Server database
+ * Example Setting Auto-commit
  */
-$db->setConnectionParameter('CharacterSet','UTF-8');
+$db->setConnectionParameter('autocommit',DB2_AUTOCOMMIT_ON);
 $db->connect('database','user','password');
 </code>
+==== PDO Driver ====
+Any parameter from the PHP [[https://www.php.net/manual/en/pdo.setattribute|PDO Attribute List]]
+<code php>
+/*
+ * Example Setting Timeout Duration
+ */
+$db->setConnectionParameter(PDO::ATTR_TIMEOUT,60);
+$db->connect(mysql:$dsn,'user','password');
+</code>