Differences

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

--- v5:reference:connection:setcharset [2021/03/08 17:59] – Link to getCharSet() dregad
+++ v5:reference:connection:setcharset [2022/07/13 03:18] (current) – mnewnham
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP info>
-Support for this command is limited to MySQL and Postgres databases. As of ADOdb V5.21, you can use the [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]] parameter with any database that supports character set configuration.
+Support for this command is limited to MySQL and Postgres databases, and as of ADOdb V5.21, this method is deprecated for MySQL databases, use [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]] instead. Because Postgres allows the character set to be modified in real-time, it can be used at any point in the script after a connection has been established.
 </WRAP>
 <WRAP right box>
@@ Line 22: / Line 23: @@
 </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>