[Forwarding this mail to the group for reference...]

---------- Forwarded message ----------
From: Aaron Digulla <[email protected]>
Date: 2013/3/4
Subject: Re: customType/forcedType by database vendor?
To: Lukas Eder <[email protected]>


2013/2/5 Lukas Eder <[email protected]>:

> @Aaron: How do you guys deal with the SQL BOOLEAN type and jOOQ across
your
> many supported database dialects?

We use NUMERIC/NUMBER/DECIMAL everywhere (date/time types, boolean and
numbers) and our own converters.

This works pretty well. Things like searching a timestamp column for a
certain a day of week is just a division/modulo operation. It also
keeps over-eager database optimizers in check and the data is dead
easy to migrate from one database platform to the other.

Regards,

-- 
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.


Reply via email to