MinJi Kim created CALCITE-1330: ---------------------------------- Summary: 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)