ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:setcharset

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
v5:reference:setcharset [2016/01/17 01:36] – ↷ Links adapted because of a move operation mnewnhamv5:reference:connection:setcharset [2022/07/13 03:18] (current) mnewnham
Line 1: Line 1:
-====== setCharSer ======+====== setCharSet ======
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP info> <WRAP info>
-Support for this command is limited to MySQL and Postgres databases, as of ADOdb V6you 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>
 <WRAP right box> <WRAP right box>
Line 14: Line 15:
 ===== Description ===== ===== 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. 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 ===== ===== Usage =====
 <code php> <code php>
Line 19: Line 23:
 </code> </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> 
  
v5/reference/connection/setcharset.1452991009.txt.gz · Last modified: 2017/04/21 11:33 (external edit)