Bug #17682 what is the result of ResultSetMetaData.getColumnType() for each MySQL type

• Submitted: 23 Feb 2006 23:22
• Modified: 21 Aug 2006 17:25
• Reporter: Sergey Vladimirov
• Status: Closed
• Category: Connector / J Documentation
• Severity: S4 (Feature request)
• Assigned to: MC Brown
• CPU Architecture: Any

[23 Feb 2006 23:22] Sergey Vladimirov

Description:
Need to add to documentation what is the result of ResultSetMetaData.getColumnType() corresponding to each MySQL type.

For example:
MySQL LONGTEXT -> Types.LONGVARCHAR

How to repeat:
http://dev.mysql.com/doc/refman/5.1/en/cj-type-conversions.html

[24 Feb 2006 12:16] Valeriy Kravchuk

Thank you for a documentation request. Yes, explicit list may be useful on that page.

[21 Aug 2006 15:03] MC Brown

I've added a new column to the table to show the output of ResultSetMetaData.getColumnTypeName, which corresponds to the Java SQL Types, and provided a link to that info.

[21 Aug 2006 17:25] Sergey Vladimirov

Can you provide a link, please?

Checked this, nothing changed:
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-type-conversions.html