01.05.2018 16:19, Adriano dos Santos Fernandes wrote:
What should be used by default ?
It should match functionality and default of SET DECFLOAT, i.e., be
default the new behavior (describe types with TZ as types with TZ).
Problematic clients will use the legacy option.
How? Legacy application cannot send new queries. Is "SET DECFLOAT" command allowed in
attach triggers?
There is session time zone. Session time zone is currently defined as
default with the server time zone.
We may think that's not ideal and session time zone should be defined
with the client time zone initially. But that per se is not correctly
too. In web applications the middle-ware (database client) does not
represent the user's session too. And it may be very problematic for
compatibility.
Client library can add a timezone item into DPB if it is not provided by application,
as it is done for application name now. Midware can set this value to whatever they like.
--
WBR, SD.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
