[
https://issues.apache.org/jira/browse/CALCITE-1330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15392885#comment-15392885
]
MinJi Kim commented on CALCITE-1330:
------------------------------------
https://github.com/apache/calcite/pull/260
> DB2 does not support character sets in data type
> ------------------------------------------------
>
> Key: CALCITE-1330
> URL: https://issues.apache.org/jira/browse/CALCITE-1330
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: MinJi Kim
> Assignee: Julian Hyde
>
> I have a very small db2 database, and it does not support "varchar(100)
> CHARACTER SET `ISO-8859-1`".
> {code}
> db2 => select TS, cast(TS as varchar(100)) from mydb.mytimestamp
> TS 2
> --------------------------
> ----------------------------------------------------------------------------------------------------
> 2016-07-18-01.02.03.000000 2016-07-18-01.02.03.000000
> 1 record(s) selected.
> {code}
> {code}
> db2 => select TS, cast(TS as varchar(100) CHARACTER SET "ISO-8859-1") from
> mydb.mytimestamp
> SQL0104N An unexpected token "CHARACTER SET "ISO-8859-1"" was found following
> "t(TS as varchar(100)". Expected tokens may include: "<space>".
> SQLSTATE=42601
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
