v5:reference:connection:setcharset
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:reference:connection:setcharset [2017/04/21 11:50] – external edit 127.0.0.1 | v5:reference:connection:setcharset [2021/03/08 17:52] – Oracle and Interbase are not supported (functions not in driver) dregad | ||
---|---|---|---|
Line 2: | Line 2: | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP info> | <WRAP info> | ||
- | Support for this command is limited to MySQL, | + | 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 21: | Line 21: | ||
===== 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