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

          Attachments

            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