Bug #52603 Various ODBC errors
Submitted: 5 Apr 2010 18:15 Modified: 6 Apr 2010 5:40
Reporter: Angel Rivero Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Windows Severity:S1 (Critical)
Version:5.1.45 OS:Windows (XP SP 3)
Assigned to: CPU Architecture:Any

[5 Apr 2010 18:15] Angel Rivero
Description:
I'm trying to insert some data into my DB MYSQL, an error messages is shown:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community]Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community]Incorrect string value: '\xC2\x93un p...' for column 'quote' at row 1

Can someone help me? Any help would be very much appreciated.
Many thanks to any who can help me out with this.

AR

How to repeat:
I'm trying to insert some data into my DB MYSQL, an error messages is shown:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community]Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community]Incorrect string value: '\xC2\x93un p...' for column 'quote' at row 1

Can someone help me? Any help would be very much appreciated.
Many thanks to any who can help me out with this.

AR
[6 Apr 2010 5:40] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Please read at http://dev.mysql.com/doc/refman/5.1/en/charset.html about how to work with different character sets and collations.
[6 Apr 2010 5:45] Tonci Grgin
Hi Angel and thanks for your report.

Unfortunately, there is *no* bug report presented here. What you're actually asking from me is to read the manual for you...

Please do not post "programing problems" reports in BugsDB, forums are more appropriate place for that.

So, as Sveta said, this is not a bug and the manual will tell you why.