note 129649 added to mysqli.get-charset

From: 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

« previous php.notes (#221420) next »