Extremely ODD behavior

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
xterra
Forum Commoner
Posts: 69
Joined: Mon Mar 06, 2006 12:52 pm

Extremely ODD behavior

Post 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?
Attachments
orderby.JPG
orderby.JPG (37.56 KiB) Viewed 393 times
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Extremely ODD behavior

Post by onion2k »

That is a bit odd. What is the column's datatype (I assume either VARCHAR or CHAR) and collation?
xterra
Forum Commoner
Posts: 69
Joined: Mon Mar 06, 2006 12:52 pm

Re: Extremely ODD behavior

Post by xterra »

name is text

id & mid are int(11).
xterra
Forum Commoner
Posts: 69
Joined: Mon Mar 06, 2006 12:52 pm

Re: Extremely ODD behavior

Post by xterra »

collation for name is latin1_swedish_ci
Post Reply