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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: program at cellenser dot de
New email:
PHP Version: OS:

 

 [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 08:00:01 2026 UTC