Liquibase Core
  1. Liquibase Core
  2. CORE-904

NVARCHAR should be mapped to VARCHAR for HSQLDB

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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]
      
      1. CORE-904.patch
        1.0 kB
        Wesley Hartford

        Activity

        Hide
        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 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 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 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
        Nathan Voxland added a comment -

        Applied, thanks!

        Show
        Nathan Voxland added a comment - Applied, thanks!

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development