If you have to deal with the Oracle DB (11g), Boolean values have no specific datatype yet. Some uses number - a SMALLINT, some uses a character - VARCHAR(1). Number or Character - which to choose? This post illustrates both approaches for the Oracle DB for Java with the major Persistence APIs JDBC and JPA.