In my database I have french character
When I do "select * from customer order by firstname"
I get result in this order
Eric
Ezeb
Isabelle
Ziggy
Éric
Éve
But would like to get
Eric
Éric
Éve
Ezeb
Isabelle
Ziggy
In other word, I would like É be considered like a E ... the same goes with
ÀÛÊ etc etc
Is there a way to do this?
Eric