MySQL Forums
Forum List  »  Stored Procedures

Re: Illegal Collation
Posted by: Peter Brawley
Date: March 20, 2013 10:29AM

MySQL wouldn't allow latin1_swedish_ci collation on a UTF8 expression, so one of those user vars isn't utf8. Is the editor writing the script that they came from using latin1 (cp1252)? Did you try prefixing the values with _utf8?

Options: ReplyQuote


Subject
Views
Written By
Posted
2439
February 28, 2013 04:12AM
1059
February 28, 2013 11:56AM
1127
February 28, 2013 08:56PM
1046
March 01, 2013 06:08AM
1196
March 01, 2013 09:59AM
1063
March 01, 2013 11:43AM
1105
March 01, 2013 04:45AM
1818
March 20, 2013 01:10AM
Re: Illegal Collation
1228
March 20, 2013 10:29AM


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.