public boolean isCaseSensitive(int column) throws java.sql.SQLException {
  Field field=getField(column);
  int sqlType=field.getSQLType();
switch (sqlType) {
case Types.BIT:
case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
case Types.BIGINT:
case Types.FLOAT:
case Types.REAL:
case Types.DOUBLE:
case Types.DATE:
case Types.TIME:
case Types.TIMESTAMP:
    return false;
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
  if (field.isBinary()) {
    return true;
  }
String collationName=field.getCollation();
return ((collationName != null) && !collationName.endsWith("_ci"));
default :
return true;
}
}

public boolean isCaseSensitive ( int column ) throws java . sql . SQLException { Field field = getField ( column ) ; int sqlType = field . getSQLType ( ) ; switch ( sqlType ) { case Types . BIT : case Types . TINYINT : case Types . SMALLINT : case Types . INTEGER : case Types . BIGINT : case Types . FLOAT : case Types . REAL : case Types . DOUBLE : case Types . DATE : case Types . TIME : case Types . TIMESTAMP : return false ; case Types . CHAR : case Types . VARCHAR : case Types . LONGVARCHAR : if ( field . isBinary ( ) ) { return true ; } String collationName = field . getCollation ( ) ; return ( ( collationName != null ) && ! collationName . endsWith ( "_ci" ) ) ; default : return true ; } }
does a column ' s case matter ?
