[eluser]Zeff[/eluser]
Hi folks,
In an application I use a simple query to get (and
sort asc.)
email addresses out of a database table. In the model I use:
Code:
$this->db->select();
$this->db->from('subscribers');
$this->db->orderby('email', 'asc');
$query = $this->db->get();
...
Email addresses are returned sorted, but those in uppercase (or first letter -) come first (nicely sorted alphabetically) and the lower cased addresses follow after the upper case list (also nicely sorted from a-z)...
e.g.
Does anyone know whether this an underlying MySql problem or typical for Active Record class get/orderby?
It would be great if someone can give me a workaround...
Thanks in advance!
Kind regards,
Zeff