Req #66637 [Opn->Wfx]: Please don't remove sql_regcase

Edit report at https://bugs.php.net/bug.php?id=66637&edit=1 ID: 66637 Updated by: requinix@php.net Reported by: marco at thenetworksolution dot it Summary: Please don't remove sql_regcase -Status: Open +Status: Wont fix Type: Feature/Change Request Package: *Regular Expressions PHP Version: 5.4.24 Block user comment: N Private report: N New Comment: It has been deprecated because there are better alternatives: * In PHP: using the PCRE functions and the /i flag for case-insensitivity. * In SQL: depends on the DBMS but many problems can be solved by using the right charset and collation. In MySQL you'd use, for example, utf8_general_ci on the column. [1] [1] http://dev.mysql.com/doc/refman/5.6/en/charset-general.html Previous Comments: ------------------------------------------------------------------------ [2014-02-03 20:05:51] marco at thenetworksolution dot it Description: ------------ Just noticed that I've just reimplemented in my project the sql_regcase. Please don't remove, it is useful in implementing accent insensitive searches on top of MySQL. --- From manual page: http://www.php.net/function.sql-regcase --- ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=66637&edit=1