note 128057 added to mysqlinfo.concepts.charset
| From: | legrand dot jeremie at gmail dot com | Date: | Mon, 26 Dec 2022 14:20:24 +0000 |
| Subject: | note 128057 added to mysqlinfo.concepts.charset | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-220011@lists.php.net to get a copy of this message | ||
After setting the charset, you should define the 'collation' too, to give information on
how sorting results on requests. By default, it is 'utf8mb4_general_ci', which is a
simplified set of sorting rules. For the official rules, edicted by Unicode, it should be
'utf8mb4_unicode_ci'.
For example:
\mysqli_set_charset($hdl, 'utf8mb4');
\mysqli_query($hdl, 'SET collation_connection = utf8mb4_unicode_520_ci');
----
Server IP: 45.112.84.4
Probable Submitter: 185.85.3.175 (proxied: 37.58.184.234)
----
Manual Page -- https://php.net/manual/en/mysqlinfo.concepts.charset.php
Edit -- https://main.php.net/note/edit/128057
Del: integrated -- https://main.php.net/note/delete/128057/integrated
Del: useless -- https://main.php.net/note/delete/128057/useless
Del: bad code -- https://main.php.net/note/delete/128057/bad+code
Del: spam -- https://main.php.net/note/delete/128057/spam
Del: non-english -- https://main.php.net/note/delete/128057/non-english
Del: in docs -- https://main.php.net/note/delete/128057/in+docs
Del: other reasons-- https://main.php.net/note/delete/128057
Reject -- https://main.php.net/note/reject/128057
Search -- https://main.php.net/manage/user-notes.php