Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
xterra
- Forum Commoner
- Posts: 69
- Joined: Mon Mar 06, 2006 12:52 pm
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 (37.56 KiB) Viewed 394 times
-
onion2k
- Jedi Mod
- Posts: 5263
- Joined: Tue Dec 21, 2004 5:03 pm
- Location: usrlab.com
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
Post
by xterra »
name is text
id & mid are int(11).
-
xterra
- Forum Commoner
- Posts: 69
- Joined: Mon Mar 06, 2006 12:52 pm
Post
by xterra »
collation for name is latin1_swedish_ci