v5:reference:connection:setcharset
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
v5:reference:setcharset [2016/01/17 01:36] – ↷ Links adapted because of a move operation mnewnham | v5:reference:connection:setcharset [2021/03/08 17:59] – Link to getCharSet() dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | ====== |
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP info> | <WRAP info> | ||
- | Support for this command is limited to MySQL and Postgres databases, as of ADOdb V6, you can use the [[v5: | + | Support for this command is limited to MySQL and Postgres databases. As of ADOdb V5.21, you can use the [[v5: |
</ | </ | ||
<WRAP right box> | <WRAP right box> | ||
Line 14: | Line 14: | ||
===== Description ===== | ===== Description ===== | ||
The function '' | The function '' | ||
+ | |||
+ | See [[v5: | ||
+ | |||
===== Usage ===== | ===== Usage ===== | ||
<code php> | <code php> | ||
Line 21: | Line 24: | ||
===== Workaround for setting server side character set on MySQL ===== | ===== Workaround for setting server side character set on MySQL ===== | ||
<code php> | <code php> | ||
- | $SQL = | + | $SQL = " |
- | "SET character_set_results = 'utf8', | + | |
- | | + | character_set_client |
- | character_set_connection = 'utf8', | + | character_set_connection = 'utf8mb4', |
- | | + | character_set_database |
- | character_set_server = 'utf8'" | + | character_set_server |
$db-> | $db-> | ||
</ | </ | ||
v5/reference/connection/setcharset.txt · Last modified: 2022/07/13 03:18 by mnewnham