Uploaded image for project: 'Liquibase Core'
  1. Liquibase Core
  2. CORE-904

NVARCHAR should be mapped to VARCHAR for HSQLDB

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.0.2
    • Component/s: None
    • Environment:

      HSQLDB 1.8.0.10

      Description

      HSQLDB does not support a type called NVARCHAR, but supports Unicode in VARCHAR columns. A mapping should be added to use the VARCHAR type where NVARCHAR is specified for HSQLDB.

      java.sql.SQLException: Wrong data type: NVARCHAR in statement [CREATE TABLE ... ZONE NVARCHAR]
      

        Gliffy Diagrams

          Activity

          Hide
          wesley Wesley Hartford added a comment -

          List of supported data types for HSQLDB is available at http://www.hsqldb.org/doc/guide/ch09.html#datatypes-section

          Show
          wesley Wesley Hartford added a comment - List of supported data types for HSQLDB is available at http://www.hsqldb.org/doc/guide/ch09.html#datatypes-section
          Hide
          wesley Wesley Hartford added a comment -

          I've attached the patch I used to fix this issue locally. The patch was created against http://liquibase.jira.com/svn/CORE/tags/liquibase-parent-2.0.1

          Show
          wesley Wesley Hartford added a comment - I've attached the patch I used to fix this issue locally. The patch was created against http://liquibase.jira.com/svn/CORE/tags/liquibase-parent-2.0.1
          Hide
          nvoxland Nathan Voxland added a comment -

          Applied, thanks!

          Show
          nvoxland Nathan Voxland added a comment - Applied, thanks!

            People

            • Reporter:
              wesley Wesley Hartford
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development