Page 1 of 1

Extremely ODD behavior

Posted: Wed Aug 13, 2008 2:41 pm
by xterra
As you can see by the screenshot, the ORDER BY is failing to order some rows! It's the last record on the screenshot.

Code: Select all

SELECT * FROM `modellist` where `mid` = '57' ORDER BY `name` ASC
Isn't this weird?

Re: Extremely ODD behavior

Posted: Wed Aug 13, 2008 3:46 pm
by onion2k
That is a bit odd. What is the column's datatype (I assume either VARCHAR or CHAR) and collation?

Re: Extremely ODD behavior

Posted: Wed Aug 13, 2008 7:31 pm
by xterra
name is text

id & mid are int(11).

Re: Extremely ODD behavior

Posted: Wed Aug 13, 2008 7:31 pm
by xterra
collation for name is latin1_swedish_ci