SQL - Include default types for other binary types

[Luis Fernando Planella Gonzalez]

MySQL driver reports mediumblobs as LONGVARBINARY.
It would be nice to include default blob types for those as well.
There are also other types: BINARY and VARBINARY which could be handled the same way.

[Timo Westkämper (timo-westkamper)]

I've update the following mappings in JDBCTypeMapping :

        // BLOB
        registerDefault(Types.BINARY, Blob.class);
        registerDefault(Types.BLOB, Blob.class);
        registerDefault(Types.LONGVARBINARY, Blob.class);
        registerDefault(Types.VARBINARY, Blob.class);

BlobType variants might not be necessary.

Could you verify that the modification fixes your problems?

[Luis Fernando Planella Gonzalez (luisfpg)]

Yes, it did work.
Thanks.

[Timo Westkämper (timo-westkamper)]

Released in 2.0.3