[
https://issues.apache.org/jira/browse/CALCITE-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16887670#comment-16887670
]
pingle wang commented on CALCITE-3200:
--------------------------------------
We use java mybatis operate on mysql like:
{code:java}
<result column="public_api_config" property="publicApiConfig"
jdbcType="LONGVARCHAR" />
{code}
mysql table column info:
{code:java}
CREATE TABLE `mlink_job` (
...
`public_api_config` text COMMENT 'public api config info',
...
) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8 COMMENT='mlink job info
store';{code}
> Add TEXT Data Type
> ------------------
>
> Key: CALCITE-3200
> URL: https://issues.apache.org/jira/browse/CALCITE-3200
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.20.0
> Reporter: pingle wang
> Priority: Major
> Labels: pull-request-available
> Fix For: next
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 1. SQL Server, Mysql, Oracle support TEXT data type.
> 2. java.sql.Types LONGVARCHAR is TEXT.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
