Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1330

DB2 does not support character sets in data type

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.0
    • Component/s: core
    • Labels:
      None

      Description

      I have a very small db2 database, and it does not support "varchar(100) CHARACTER SET `ISO-8859-1`".

      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.
      
      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
      

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              minjikim MinJi Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: