Re: A "MEDIUMTEXT" field in a MySQL database shows up as a VARCHAR in JDBCR4

On 4/21/15 7:40 AM, Buck Calabro wrote:

I believe the documentation calls MEDIUMTEXT a TEXT type, not a xLOB
type. It specifically says this: 'Similarly, you can regard a TEXT
column as a VARCHAR column.'

Actually, the docs describe the TEXT types as LONGVARCHAR types, which aren't constrained by normal VARCHAR length limitations.

The docs go on to say that GetColumnTypeName() on TEXT columns returns "VARCHAR," but GetColumnType() returns a value defined by the LONGVARCHAR named constant.

And so I'm in the process of front-ending GetColumnType().

And an issue is that I'm trying to blindly retrieve the length into a 5-digit packed decimal (in a standardized data structure that can't be changed), which doesn't exactly work well when you've got a length that runs 7+ digits.

--
JHHL