show table status from xxx - column types change?

[roger]

Some of the column data types returned by "show table status from xxx" seems to have changed between Connector/J 3.1.8 and later versions. From 3.1.9 all VARCHAR columns have changed to VARBINARY.

Here is a listing of the columns available by the show table status command. Switching between 3.1.8 and laters versions results in the exact same output as below but the JDBC Type is VARCHAR instead of VARBINARY.

What has happened and is this change intentional?

(Using MySQL 4.1.12-standard)

Regards

Roger

Pos Name DB Type JDBC Type
-------------------------------------------------------------------------------------
1 Name VARCHAR VARBINARY
2 Engine VARCHAR VARBINARY
3 Version BIGINT BIGINT
4 Row_format VARCHAR VARBINARY
5 Rows BIGINT BIGINT
6 Avg_row_length BIGINT BIGINT
7 Data_length BIGINT BIGINT
8 Max_data_length BIGINT BIGINT
9 Index_length BIGINT BIGINT
10 Data_free BIGINT BIGINT
11 Auto_increment BIGINT BIGINT
12 Create_time DATETIME TIMESTAMP
13 Update_time DATETIME TIMESTAMP
14 Check_time DATETIME TIMESTAMP
15 Collation VARCHAR VARBINARY
16 Checksum BIGINT BIGINT
17 Create_options VARCHAR VARBINARY
18 Comment VARCHAR VARBINARY