Item 143: How to Deal with Hibernate and Unsupported Types via the Hibernate Types Library
As a rule of thumb, strive to choose the best database column types. Take your time and scroll your database types, since most databases come with specific types that you can use. For example, MySQL’s MEDIUMINT UNSIGNED stores an integer in the range of 1 to 99999, PostgreSQL’s money type stores a currency amount with a fixed fractional precision, the cidr type holds an IPv4 or IPv6 network specification, and so on. Moreover, strive to use compact types. This will reduce the index ...
