Version: 4.0.9 Reporter: Jace Richardson —
In EE4, the enforceCharsetAndCollation() method in mysqli_connection.php adds:
$want = "\\1CHARACTER SET {$charset} COLLATE {$collation}";
whereas in EE3 it added:
$want = "DEFAULT CHARACTER SET {$charset} COLLATE {$collation}";
without the \\1.
If the conditional fails, the $want is appended to the $query raw without removing the \1 which makes the query fail.
I modifed line 249 of mysqli_connection.php from this:
$query .= ' '.$want.';';
to this:
$query .= ' '.substr($want, 2).';';
ExpressionEngine implements Markdown Extra and BBCode. Please see the Markdown Extra docs and the BBCode Wikipedia article for a full reference.
**bold**, __bold__, *italics*, _italics_, ~strike/del~, `code()`
bold, italics, strike/del, code()
Link: [link title](https://example.com)
Image: 
[blockquote]...[/blockquote], [quote]...[/quote], and Markdown style:
> Some quoted text. > > This is all one quote.
[code]...[/code], and you can also specify the language for syntax highlighting, [code=php]...[/code]
GitHub flavored Markdown code fences are also supported:
```
public function decoderRing($str)
{
return str_rot13($str);
}
```