#2495 SQL Error 1406: Data too long for BIT column

[Anonymous]

Originally created by: benjamin.howarth.cmd (code.google.com)

What exact steps will reproduce the problem?
1. Create a database locally on MySQL 5.5.10, collation unimportant;
2. Create a table inside the database, with a BIT column;
3. Create a database on a remote server (in this instance, MySQL 5.5.12);
4. Attempt to export the database, using DELETE + INSERT data, from the local server to the remote server.

What was the expected output?
Table to be exported with data.

What happened instead?
Errors: SQL Error (1406): Data too long for column '%NAME%' at row %ROW%. (Column refers to the BIT column).

Suggested fix (optional)?

Version used?
HeidiSQL revision: 6.0.0.3907
MySQL Server version: 5.5.10 local, 5.5.12 remote.
Operating system: Windows 7 Ultimate N x64 local, Windows Server 2008 Standard x64 (virtual server on Parallels platform) remote.

[Anonymous]

Originally posted by: benjamin.howarth.cmd (code.google.com)

Just realised this is a duplicate of issue 2382: https://code.google.com/p/heidisql/issues/detail?id=2382

[Anonymous]

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Mergedinto: 2382
Status: Duplicate