#113 NVARCHAR support

[Teddy Brielle]

Hi,

I try to create a table in an Access 2007 file from a ResultSet using

com.healthmarketscience.jackcess.util.ImportUtil.importResultSet(ResultSet, Database, String)

The ResultSet is created from a table in a SQL Server database. One of the columns is typed as NVARCHAR. The import fails with the following exception

java.sql.SQLException: Unsupported SQL type: -9
at com.healthmarketscience.jackcess.DataType.fromSQLType(DataType.java:465)
at com.healthmarketscience.jackcess.ColumnBuilder.setSQLType(ColumnBuilder.java:117)
at com.healthmarketscience.jackcess.util.ImportUtil.toColumns(ImportUtil.java:90)
at com.healthmarketscience.jackcess.util.ImportUtil.importResultSet(ImportUtil.java:181)
at com.healthmarketscience.jackcess.util.ImportUtil.importResultSet(ImportUtil.java:153)
at com.healthmarketscience.jackcess.util.ImportUtil.importResultSet(ImportUtil.java:131)

Is it planned to support NVARCHAR in future Jackcess releases ?

Thanks.

[James Ahlborn]

this is fixed in the trunk and will be in the 2.0.8 release. i added all the 'N' char types and the jdk 8 "with timezone" types.

[Teddy Brielle]

Thank you !