Search found 1 match
- 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...