When I perform this query to the database : "SELECT Name FROM Thirds ORDER BY Name;", here is what I obtain :
Celine Céline Eric Marc Éric Zoe céline eric Éric éric
This does NOT appear ordered to me...
Moreover, it does not appear correct! "Éric" appears twice, once before "Zoe" and again before "éric". Why is that?
Is there something I should know that I don't about how SQL interpret capital letters ?
It looks like it is going on strict ASCII numeric order (a la strcmp), with the exception of the error I mention above.
michael
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
