php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Doc Bug #66844 sort case insesitive
Submitted: 2014-03-07 12:53 UTC Modified: 2014-03-20 16:13 UTC
From: program at cellenser dot de Assigned:
Status: Not a bug Package: *General Issues
PHP Version: Irrelevant OS: Apache Version Apache/2.2.16 (D
Private report: No CVE-ID: None
View Developer Edit
 [2014-03-07 12:53 UTC] program at cellenser dot de 
Description:
------------
How can I sort an array, ignoring capital letters?
Every instruction is about seperating them, but that is, what my databas does.



thanks, LB

mysqlnd 5.0.8-dev 

Test script:
---------------
$querys='select wort, id from ortho where (id>0) order by wort ASC';	

Expected result:
----------------
what I want is:
Ruf
rufen
Zuber
zubern

Actual result:
--------------
what I get is:
Ruf
Zuber
rufen
zubern

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-03-20 16:13 UTC] uw@php.net
-Status: Open +Status: Not a bug
 [2014-03-20 16:13 UTC] uw@php.net 
When using the mysqli extension together with the mysql extension
you have to use the same libraries and include files. mysqli
extension requires the location of mysql_config file, mysql
extension requires the path of your mysql installation.

If you installed MySQL 4.1 for example with prefix /usr/local/mysql-4.1
your configure settings should be
--with-mysql=/usr/local/mysql-4.1
--with-mysqli=/usr/local/mysql-4.1/bin/mysql_config

You are asking a SQL question not reporting a PHP bug. PHP or MySQL user list are a better place to ask. And, don't miss the string functions in the MySQL reference manual.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Thu Oct 08 09:00:02 2026 UTC