Differences

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

--- v5:reference:connection:setcharset [2017/04/21 11:50] – external edit 127.0.0.1
+++ v5:reference:connection:setcharset [2018/06/11 10:14] – [Workaround for setting server side character set on MySQL] Use mysql utf8mb4 charset (#426) dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP info>
-Support for this command is limited to MySQL,Oracle,Interbase 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, Oracle, Interbase 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.
 </WRAP>
 <WRAP right box>
@@ Line 21: / Line 21: @@
 ===== Workaround for setting server side character set on MySQL =====
 <code php>
-$SQL =
+$SQL = "SET
- "SET character_set_results = 'utf8',
+    character_set_results    = 'utf8mb4',
- character_set_client = 'utf8',
+    character_set_client     = 'utf8mb4',
-character_set_connection = 'utf8',
+    character_set_connection = 'utf8mb4',
- character_set_database = 'utf8',
+    character_set_database   = 'utf8mb4',
-character_set_server = 'utf8'");
+    character_set_server     = 'utf8mb4'";
 $db->execute($SQL);
 </code>