COLLATION not valid
Posted by: Brandon Metcalf
Date: July 08, 2011 11:05AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
COLLATION not valid
7178
July 08, 2011 11:05AM
3144
July 08, 2011 11:35AM
2936
July 08, 2011 09:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.