Subscribe to the newsletter here Tweet of the Day Our followers, users and customers are shouting their love for jOOQ to the world. Here are: Ben Hood who is constantly discovering new useful features in jOOQ. https://twitter.com/0x6e6562/status/436753836540452864 Antoine Comte who is skipping MyBatis to jump directly to jOOQ (in French) https://twitter.com/comte_a/status/433699690069385216 Both guys are absolutely right, of … Continue reading jOOQ Newsletter: February 26, 2014
SQL and booleans, some trivia
Some trivia about SQL and booleans: SQL 1992 defines three values for a boolean: <truth value> ::= TRUE | FALSE | UNKNOWN True booleans aren't always supported, though. Here's the truth table of boolean support: SQL DialectSupports booleansDB20 (use 1/0 instead)Derbytrue (you can safely use true/false)H2trueHSQLDBtrueIngrestrueMySQLtrueOracle0PostgrestrueSQL Server0SQLite0Sybase ASE0Sybase SQL Anywhere0 Trivia... but nice to know.