On 11/15/05, <b class="gmail_sendername">Ludovic Dubost</b> &lt;<a href="mailto:ludovic@pobox.com">ludovic@pobox.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Hi<br><br>The actual error in the exception log is:<br><br>java.sql.BatchUpdateException:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.executeBatch(<br><br>Apparently there is an illegal setup in MySQL. You should tweak your<br>mysql collation settings.<br>
I've never seen such an error before.</blockquote><div><br>
I'm not sure where to tweak these in Windows (I'm more accustomed to Linux setups). Any clues?<br>
<br>
It's also worth mentioning, I used mysql 5, and set it to use UTF8
encoding; this seems to be related. Maybe I should re-install using
latin1?<br>
<br>
--JB <br>
</div><br><br>
</div><br>