Bug #49102 | Exception retrieving guids ending in 0x20 from 4.1 databases | ||
---|---|---|---|
Submitted: | 25 Nov 2009 15:15 | Modified: | 3 Dec 2009 11:37 |
Reporter: | Olivier Poquet | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 5.2.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[25 Nov 2009 15:15]
Olivier Poquet
[26 Nov 2009 13:31]
Tonci Grgin
Olivier, Wlad confirmed your test works against MySQL server 6.0 so it really might be server issue. What happens if you append something after 0x20? Does then this new character gets written to database (ie. instead of 0x20 put 0x20 0x10 or whatever)?
[26 Nov 2009 13:46]
Tonci Grgin
One more note... *Both* MySQL server 4.1 and c/NET 5.2 (almost) are EOL-ed so it might be a good thing to upgrade.
[30 Nov 2009 17:20]
Olivier Poquet
The behavior of stripping trailing space characters from binary columns is a server issue, see http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html and see the bulleted list midway down. Unfortunately upgrading the server isn't an option for me at the moment. I'm quite content if you guys decide not to fix this in the connector given that it only affects ancient mysql server versions and I can work around it. It would, however, be nice if this issue were documented given that the connector is still supposed to support mysql versions before 5.0.15, old as they are.
[3 Dec 2009 11:37]
Tonci Grgin
Olivier, as there seem not to be any valid reason for complicating connector code cause of bugs in EOL-ed server, I'm closing this one.