Differences

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

--- v5:reference:setcharset [2016/01/17 01:36] – ↷ Links adapted because of a move operation mnewnham
+++ v5:reference:connection:setcharset [2022/07/13 03:18] (current) – mnewnham
@@ Line 1: / Line 1: @@
-====== setCharSer ======
+====== setCharSet ======
 ~~NOTOC~~
 <WRAP info>
-Support for this command is limited to MySQL and Postgres databases, as of ADOdb V6, 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 14: / Line 15: @@
 ===== Description =====
 The function ''setCharSet()'' set the **client side** character set to the specified set. The function returns true or false based on the success of command execution.
+See [[v5:reference:connection:getcharset|getCharSet()]].
 ===== Usage =====
 <code php>
@@ Line 19: / Line 23: @@
 </code>
-===== Workaround for setting server side character set on MySQL =====
-<code php>
-$SQL =
- "SET character_set_results = 'utf8',
- character_set_client = 'utf8',
-character_set_connection = 'utf8',
- character_set_database = 'utf8',
-character_set_server = 'utf8'");
-$db->execute($SQL);
-</code>