Search found 1 match

by GuyGordon
Wed Jun 13, 2007 4:41 pm
Forum: Databases
Topic: How to collate hyphens with spaces?
Replies: 0
Views: 333

How to collate hyphens with spaces?

I am working with a MySQL table of old magazine names. With the default latin1_swedish_ci, when I list magazines alphabetically names like 'Action-Packed Detective' end up after all names like 'Action Packed Western', because the hyphen sorts below the space. I want to treat hyphens and spaces the s...