How to use

isTextual

method

in

com.healthmarketscience.jackcess.DataType

public int getUnitSize(JetFormat format) {
 if((format != null) && isTextual()) {
  return format.SIZE_TEXT_FIELD_UNIT;
 }
 return _unitSize;
}

  @Override
  public Object handleRowError(Column cl, byte[] bt, Location location, Exception ex)
      throws IOException {
    if (cl.getType().isTextual()) {
      Logger.logParametricWarning(Messages.INVALID_CHARACTER_SEQUENCE,
          cl.getTable().getName(), cl.getName(), new String(bt));
    }
    throw new IOException(ex.getMessage());
  }
});

private void setColumnSortOrder(ColumnBuilder column) {
  // set the sort order to the db default (if unspecified)
  if(column.getType().isTextual() && (column.getTextSortOrder() == null)) {
   column.setTextSortOrder(getDbSortOrder());
  }
}

@Override
public boolean matches(Table table, String columnName, Object value1,
            Object value2)
{
 if(!table.getColumn(columnName).getType().isTextual()) {
  // use simple equality
  return SimpleColumnMatcher.INSTANCE.matches(table, columnName, 
                        value1, value2);
 }
 // convert both values to Strings and compare case-insensitively
 try {
  CharSequence cs1 = ColumnImpl.toCharSequence(value1);
  CharSequence cs2 = ColumnImpl.toCharSequence(value2);
  return((cs1 == cs2) ||
      ((cs1 != null) && (cs2 != null) &&
      cs1.toString().equalsIgnoreCase(cs2.toString())));
 } catch(IOException e) {
  throw new RuntimeIOException("Could not read column " + columnName 
                 + " value", e);
 }
}

      CustomToStringStyle.ignoreNull(getCalculationContext()));
if(_type.isTextual()) {
 sb.append("compressedUnicode", isCompressedUnicode())
  .append("textSortOrder", getTextSortOrder());

if(col.getType().isTextual()) {

if(!getType().isTextual()) {
 throw new IllegalArgumentException(withErrorContext(
   "Only textual columns allow unicode compression (text/memo)"));

!getType().isTextual() ||
(Boolean)props.getValue(PropertyMap.ALLOW_ZERO_LEN_PROP,
            Boolean.TRUE);