Bug #58585 | Collation bug when using if in where clause on string field | ||
---|---|---|---|
Submitted: | 30 Nov 2010 8:20 | Modified: | 30 Nov 2010 23:07 |
Reporter: | Kristof Van Cleemput | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0,5.1 (All?) | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | bug, collate, IF, Illegal mix of collations, missing autocasting, where |
[30 Nov 2010 8:20]
Kristof Van Cleemput
[30 Nov 2010 8:23]
Kristof Van Cleemput
Better Synopsis
[30 Nov 2010 23:07]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Read at http://dev.mysql.com/doc/refman/5.1/en/charset-collation-expressions.html and http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#function_strcmp about collations and string comparison.