Doc #66844 [Opn->Nab]: sort case insesitive
| From: | uw@php.net | Date: | Thu, 20 Mar 2014 16:13:49 +0000 |
| Subject: | Doc #66844 [Opn->Nab]: sort case insesitive | ||
| References: | 1 | Groups: | php.doc.bugs |
| Request: | Send a blank email to doc-bugs+get-11085@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=66844&edit=1
ID: 66844
Updated by: uw@php.net
Reported by: program at cellenser dot de
Summary: sort case insesitive
-Status: Open
+Status: Not a bug
Type: Documentation Problem
Package: *General Issues
Operating System: Apache Version Apache/2.2.16 (D
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2014-03-07 12:53:00] 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
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=66844&edit=1