| Bug #7697 | Illegal mix of collations(latin1_swedish_ci,IMPLICIT) | ||
|---|---|---|---|
| Submitted: | 6 Jan 2005 5:28 | Modified: | 7 Jan 2005 0:36 |
| Reporter: | chen howell | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.1 | OS: | Windows (win2k) |
| Assigned to: | CPU Architecture: | Any | |
[7 Jan 2005 0:36]
MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL.
Description: Illegal mix of collations(latin1_swedish_ci,IMPLICIT) Unlucky, I'm encountering the famous character set problem.I work a J2EE web application using mysql4.1,and connecting by hibernate.If I add property "useUnicode" and "characterEncoding" into jdbc connection url ,It will occur query wrong,but insert right.If I remove them,What I will insert will be wrong character but only"?". How can I do? How can I set default-character-set\character_set_client\ character_set_results \ character_set_connection,and jdbc connection url? Or,reslove by other way. thanks. cenghao 2005.1.6 HangZhou.Zhejiang.China How to repeat: cenghao@hotmail.com,cenghao@163.com