COLLATION not valid

[Brandon Metcalf]

In 5.1.37, the following works:

select * from subid where sourceID=17467 and subid='ymjjc2vlaw' collate latin1_swedish_ci;

However, in 5.5.12 this error is generated:

ERROR 1253 (42000): COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

I've found similar issues in my searches, but it's not clear to me how to modify the query in order for this to work. Any help is appreciated.