How to use

ValueStringIgnoreCase

in

org.lealone.db.value

@Override
protected ValueString getNew(String s) {
  return ValueStringIgnoreCase.get(s);
}

/**
 * Get or create a case insensitive string value for the given string.
 * The value will have the same case as the passed string.
 *
 * @param s the string
 * @return the value
 */
public static ValueStringIgnoreCase get(String s) {
  if (s.length() == 0) {
    return EMPTY;
  }
  ValueStringIgnoreCase obj = new ValueStringIgnoreCase(StringUtils.cache(s));
  if (s.length() > SysProperties.OBJECT_CACHE_MAX_PER_ELEMENT_SIZE) {
    return obj;
  }
  ValueStringIgnoreCase cache = (ValueStringIgnoreCase) Value.cache(obj);
  // the cached object could have the wrong case
  // (it would still be 'equal', but we don't like to store it)
  if (cache.value.equals(s)) {
    return cache;
  }
  return obj;
}

v = (s == null) ? (Value) ValueNull.INSTANCE : ValueStringIgnoreCase.get(s);
break;

private boolean checkIndex(ServerSession session, String value, Value indexFrom, Value indexTo) {
  if (value == null || (indexFrom == null && indexTo == null)) {
    return true;
  }
  Database db = session.getDatabase();
  if (database.getMode().lowerCaseIdentifiers) {
    Value v = ValueStringIgnoreCase.get(value);
    if (indexFrom.equals(indexTo) && db.compare(v, indexFrom) != 0) {
      return false;
    }
  } else {
    Value v = ValueString.get(value);
    if (indexFrom != null && db.compare(v, indexFrom) < 0) {
      return false;
    }
    if (indexTo != null && db.compare(v, indexTo) > 0) {
      return false;
    }
  }
  return true;
}

  return ValueString.get(s);
case STRING_IGNORECASE:
  return ValueStringIgnoreCase.get(s);
case STRING_FIXED:
  return ValueStringFixed.get(s);

  return ValueStringIgnoreCase.get(readString(buff));
case Value.STRING_FIXED:
  return ValueStringFixed.get(readString(buff));

  return ValueString.get(readString());
case Value.STRING_IGNORECASE:
  return ValueStringIgnoreCase.get(readString());
case Value.STRING_FIXED:
  return ValueStringFixed.get(readString());