Differerence between hibernate types: boolean, yes_no, true

When to use each? To what do they map in the database?

What are hibernate types?

These types of mapping have data types defined as “integer”, “character”, “float”, “string”, “double”, “Boolean”, “short”, “long” etc. These are present in hibernate framework to map java data type to RDBMS data type.

Does hibernate support JSON data type?

Spring Data / Hibernate does not support JSON fields out-of-the-box, but there is a library that provides custom types for the most common database systems: hibernate-types.

Follow true_false, if you like T/F at database level. Otherwise, use yes_no, it will give you Y/N in the database.

By the way, got to know that there are some issues with these, which result in unexpected value. For example here and here, Few seems fixed already in successive updates, though.