Bug #68976 Mysql ODBC Connector and conversion of Boolean issue
Submitted: 16 Apr 2013 21:35 Modified: 1 Jul 2013 6:54
Reporter: Willam Piedfort Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.2.4 OS:Windows
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: boolean, ODBC

[16 Apr 2013 21:35] Willam Piedfort
Description:
With Tracerplus Connect, in some regions as in French version, when using the MySql ODBC driver version 5.2.4, conversion of the TracerPlus True/False checkbox values will fail when syncing to a MySql Bit(1) field. 

This issue does not occur on MySql ODBC drivers of 5.1.12 and below.

The exact message that will appear in the TracerPlus Connect event log is as follows:

    **Exception received: Input string was not in a correct format. Couldn't store <False> in <bit(1)field> Column. Expected type is Int16.

How to repeat:
Install Tracerplus 7.1.1 build 709 (Desktop and Connect) from http://www.saisie-mobile.eu/rubrique1.html 
Create a mobile application with a 'checkbox' field, install it on your mobile device,  synchronise it with Tracerplus Connect with the Mysql database table in which you have the corresponding field as bit(1) .
test with french version of 5.2.4 : you get the error. Install 5.1.12 and create an Odbc link to the same database , change the link in Tracerplus Connect to the new odbc link : no more error and good data transfert.

Tracerplus is edited by PTS - http://www.tracerplus.com/

Suggested fix:
Reinstall Connector 5.1.12
[19 Apr 2013 9:35] Bogdan Degtyariov
Unfortunately, your setup needs MS Windows CE/Mob device, which is a problem.

Can you try a workaround: use NO_SSPS=1 option in the connection string or set it through the driver GUI: Details -> Misc -> Prepare Statements on the Client.
[20 May 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[31 May 2013 8:15] Bogdan Degtyariov
Hi William,

Do you have any comments on this bug report?
[1 Jul 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[1 Jul 2013 6:54] Bogdan Degtyariov
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you.