On 17-2-2019 12:08, Mark Rotteveel wrote:
Does isc_dpb_session_time_zone have an explicit default value? What I
mean is, can you set a value (maybe local?) that behaves as if the value
is not set (and thus uses the DefaultTimeZone config or system time zone)?
In addition, is isc_dpb_session_time_zone case insensitive (ie will
Europe/Amsterdam behave the same as EUROPE/AMSTERDAM or europe/amsterdam)?
What happens if a value is provided that does not exist? Will the
connection terminate with an error, will it provide a warning, or will
it silently use the DefaultTimeZone config or system time zone?
As background to this question, Jaybird 4 is going to default to setting
the session time zone to the Java Virtual Machine default time zone
because of a number of JDBC expectations, and users who want the
equivalent to the 'old' behaviour will need to 'unset' it.
It would be helpful if Firebird already had an explicit default value
(as then I can just document that, and I don't need to have logic to
treat a Jaybird specific value as 'don't set').
The case (in)sensitivity and 'invalid' value behaviour is just something
I want to be aware of (and maybe document).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
