> For the char(1), what is the difference with tinyint ? > They both are stored in on byte.
char(1) is subject to character set translation. char(1) is displayed as a character in tools for sending ad-hoc queries. It is also usually returned as some string datatype to programs. char(1) data will throw an SQL exception if you try to add 1.5 to one. In many situations, storage is what interests you least about a data type. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
