Better column type translation for very large MEMO/OLE types in the Database.copyTable logic

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@360 f203690c-595d-4dc9-a70b-905162fa7fd2

1 files changed, 4 insertions, 2 deletions

diff --git a/src/java/com/healthmarketscience/jackcess/DataType.java b/src/java/com/healthmarketscience/jackcess/DataType.java
index f648fde..8e08bec 100644
--- a/src/java/com/healthmarketscience/jackcess/DataType.java
+++ b/src/java/com/healthmarketscience/jackcess/DataType.java
@@ -377,9 +377,11 @@ public enum DataType {
     // make sure size is reasonable
     int size = lengthInUnits * rtn.getUnitSize();
     if(rtn.isVariableLength() && !rtn.isValidSize(size)) {
-      // try alternate type
+      // try alternate type.  we always accept alternate "long value" types
+      // regardless of the given lengthInUnits
       DataType altRtn = ALT_SQL_TYPES.get(sqlType);
-      if((altRtn != null) && altRtn.isValidSize(size)) {
+      if((altRtn != null) &&
+         (altRtn.isLongValue() || altRtn.isValidSize(size))) {
         // use alternate type
         rtn = altRtn;
       }