Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 223729

Summary: MySQL Binary/VarBinary Data Types Improperly Processed
Product: [Tools] Data Tools Reporter: David E. Williams <dwilliams>
Component: EnablementAssignee: Project Inbox <dtp.enablement-inbox>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: bfitzpat, legnome57, pierre.queinnec
Version: 1.5.2Keywords: helpwanted
Target Milestone: future   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description David E. Williams CLA 2008-03-24 17:11:17 EDT 
Build ID: M20080221-1800

Steps To Reproduce:
1. In Data Source Explorer, right-click on a table known to contain a binary type column, select 'Edit', results in: Error initializing the editor -- Cannot edit table. An unknown or unsupported data type encountered for column <column_name>.
2.On right-click, select "Sample Data", results in: Status: Success, Results: all columns displayed except binary data is interpreted and displayed improperly.


More information:
DTP 1.5.2 200802201

May be related to bug:

195855 Summary: Can't support MySQL UNSIGNED data type
Comment 1 David E. Williams CLA 2008-03-24 17:15:13 EDT 
MySQL JDBC Driver: mysql-connector-java-5.1.6-bin.jar
Comment 2 Philippe Weber CLA 2008-10-09 06:45:14 EDT 
As for 195855, current (1.6.1) enablement project for mysql now defines BINARY and VARBINARY datatype.

So this bug could be resolved.
Comment 3 Pierre Queinnec CLA 2012-05-18 14:43:54 EDT 
Hi! I just verified this with the current master, it works.

For future reference, I used:

CREATE TABLE binarytest1
(
    id int NOT NULL AUTO_INCREMENT,
    name varchar(100) NOT NULL UNIQUE COMMENT 'the name',
    date date COMMENT 'a date',
    myvardata varbinary(10),
    mydata binary(200),
    PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8;

The Data Source Explorer view displays everything correctly; the Data > Edit feature works fine; and the Data > Sample Contents correctly displays the test data I inserted.

I'll resolve this as FIXED, please re-open if needed.
Many thanks for the report.