Bug #51241 | Field collation metadata not correct in 5.1 | ||
---|---|---|---|
Submitted: | 17 Feb 2010 12:25 | Modified: | 18 Feb 2010 8:14 |
Reporter: | Tonci Grgin | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
Version: | 5.1.31, 5.1.43 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[17 Feb 2010 12:25]
Tonci Grgin
[17 Feb 2010 21:27]
Alexander Barkov
This is not a bug. The "Collation" metadata column displays what you get on the client side after processing by client-server character set conversion, according to @@character_set_results. If you need the original column collation, i.e. switch off client-server conversion, you need to do: SET @@character_set_results=NULL; This is expected behaviour, I suggest to close as Not a bug.
[18 Feb 2010 8:14]
Tonci Grgin
Verily, Bar is right as always. I presumed ini files to be the same but they are not. set character_set_results=NULL; solves the problem and is probably the reason why connectors work cause they set it this way by default. Thanks Bar.