Welcome Guest, Not a member yet? Register   Sign In
Orderby: uppercase Z > lowercase a
#1

[eluser]PeterGreffen[/eluser]
Hello,

An "ORDER BY" like ($this->db->orderby('name'));
gives me this result:

1. Adam
2. Zora
3. anna
4. zanzibar
5. ...

Seems like the uppercases are higher ranked than the lowercases...
Does anyone know how to solve this?

Thank you!
P.


Messages In This Thread
Orderby: uppercase Z > lowercase a - by El Forum - 12-01-2010, 09:51 AM
Orderby: uppercase Z > lowercase a - by El Forum - 12-01-2010, 10:01 AM
Orderby: uppercase Z > lowercase a - by El Forum - 12-01-2010, 10:08 AM
Orderby: uppercase Z > lowercase a - by El Forum - 12-01-2010, 10:44 AM
Orderby: uppercase Z > lowercase a - by El Forum - 12-01-2010, 11:52 AM
Orderby: uppercase Z > lowercase a - by El Forum - 12-23-2010, 06:48 AM



Theme © iAndrew 2016 - Forum software by © MyBB