You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "MinJi Kim (JIRA)" <ji...@apache.org> on 2016/07/25 23:50:20 UTC
[jira] [Created] (CALCITE-1330) DB2 does not support character sets
in data type
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)