note 129649 added to mysqli.get-charset
| From: | jab_creations@yahoo.com | Date: | Thu, 11 Jul 2024 19:55:25 +0000 |
| Subject: | note 129649 added to mysqli.get-charset | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221420@lists.php.net to get a copy of this message | ||
On a new server this function was incorrectly returning "utf8mb4_general_ci".
I started a bug report and it turns out that:
1. The PHP team maintained an internal static list.
2. They ultimately decided to not be bothered to update that internal static list.
So as someone with the intentions on knowing exactly what is going on (e.g. Paris Michigan !== Paris
France) I now reject the use of this function.
I'm not sure about other databases though for MariaDB you can determine the many character sets
using the following SQL query:
SELECT VARIABLE_NAME, GLOBAL_VALUE, DEFAULT_VALUE
FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES
WHERE VARIABLE_NAME LIKE '%CHAR%';
----
Server IP: 45.112.84.4
Probable Submitter: 45.112.84.18 (proxied: 84.239.6.140)
----
Manual Page -- https://php.net/manual/en/mysqli.get-charset.php
Edit -- https://main.php.net/note/edit/129649
Del: integrated -- https://main.php.net/note/delete/129649/integrated
Del: useless -- https://main.php.net/note/delete/129649/useless
Del: bad code -- https://main.php.net/note/delete/129649/bad+code
Del: spam -- https://main.php.net/note/delete/129649/spam
Del: non-english -- https://main.php.net/note/delete/129649/non-english
Del: in docs -- https://main.php.net/note/delete/129649/in+docs
Del: other reasons-- https://main.php.net/note/delete/129649
Reject -- https://main.php.net/note/reject/129649
Search -- https://main.php.net/manage/user-notes.php