Sorting from mysql bug???

[eevan79]

This sorting goes me crazy .

 

Ok, here is script:

$result = mysql_query("SELECT * FROM " . $table_prefix . "users ORDER BY ".$sort." ".$ascdesc." LIMIT $offset, $users_per_page");

 

$sort is "user_name".

 

And I get following results:

First I get user starting with "K"

than "a", "b" etc.

 

It looks like this:

 

1. Korisnik

2. asdsa

3. test1

4. test2

 

etc...

 

Why I get wrong sorting by username? Other sortings work fine (date, last login etc.)

[Mchl]

Most likely you have a case sensitive collation set up for user_name column. Change to case insensitive and you should be fine.

[eevan79]

Thats it 100%. I totally forgot.

 

Thanks.