Re: [Firebird-devel] DefaultTimeZone config

2021-05-11 Thread Adriano dos Santos Fernandes
On 11/05/2021 06:23, Alex Peshkoff via Firebird-devel wrote: Also note that no implicit client time zone is passed when DefaultTimeZone is not set. Doing so would create compatibility problems with date/time functions for who is not interested in time zones. >>> May be explicit

Re: [Firebird-devel] DefaultTimeZone config

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/9/21 8:20 PM, Adriano dos Santos Fernandes wrote: On 07/05/2021 12:23, Alex Peshkoff via Firebird-devel wrote: On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_t

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Adriano dos Santos Fernandes
On 10/05/2021 12:14, Vlad Khorsun wrote: > >   Correct me if I'm wrong: when client config is present and contains > non-commented out setting DefaultTimeZone > > - with some value, other than "Auto" >   such value is passed via DPB and validated on server, using > server-side ICU > > - with va

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Vlad Khorsun
10.05.2021 17:52, Adriano dos Santos Fernandes wrote: On 10/05/2021 11:45, Vlad Khorsun wrote: People wanting a functionality should not be worried about a DLL (which in 99% of cases will be there already).   I can agree about 99% of non-Windows cases, but on Windows it is wrong assumption.

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Dimitry Sibiryakov
10.05.2021 16:45, Vlad Khorsun wrote:    May be it would be enough to use system-specific timezone functions and translate their results to ICU names/ids?..   Do you know such "translator" ? At least for Windows. AFAIU it has to be an array matching DYNAMIC_TIME_ZONE_INFORMATION::TimeZoneK

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Adriano dos Santos Fernandes
On 10/05/2021 11:45, Vlad Khorsun wrote: >> >> People wanting a functionality should not be worried about a DLL (which >> in 99% of cases will be there already). > >   I can agree about 99% of non-Windows cases, but on Windows it is wrong > assumption. > I mean 99% of people has 0% necessity of

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Vlad Khorsun
10.05.2021 17:12, Adriano dos Santos Fernandes wrote: On 10/05/2021 11:03, Dimitry Sibiryakov wrote: 10.05.2021 14:55, Adriano dos Santos Fernandes wrote: May be explicit DefaultTimeZone=Auto can turn on passing implicit client time zone? Not to say I treat it as absoluely needed, just possible

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Adriano dos Santos Fernandes
On 10/05/2021 11:03, Dimitry Sibiryakov wrote: > 10.05.2021 14:55, Adriano dos Santos Fernandes wrote: May be explicit DefaultTimeZone=Auto can turn on passing implicit client time zone? Not to say I treat it as absoluely needed, just possible solution. >>> It should be pos

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Dimitry Sibiryakov
10.05.2021 14:55, Adriano dos Santos Fernandes wrote: May be explicit DefaultTimeZone=Auto can turn on passing implicit client time zone? Not to say I treat it as absoluely needed, just possible solution. It should be possible, but requiring ICU in the client when that setting is used. Should

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Adriano dos Santos Fernandes
On 10/05/2021 08:39, Dmitry Yemanov wrote: > 09.05.2021 20:20, Adriano dos Santos Fernandes wrote: > What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_time_zone in the attachment. >>> >>> For me such behavior l

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Dmitry Yemanov
09.05.2021 20:20, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_time_zone in the attachment. For me such behavior looks suspicious (i.e. a bug to be precise). DefaultTimeZone set at

Re: [Firebird-devel] DefaultTimeZone config

2021-05-09 Thread Adriano dos Santos Fernandes
On 07/05/2021 12:23, Alex Peshkoff via Firebird-devel wrote: > On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: >> What I want to ask about if it's clear/good is that DefaultTimeZone set >> in client does not implicitly pass isc_dpb_session_time_zone in the >> attachment. > > For me such beh

Re: [Firebird-devel] DefaultTimeZone config

2021-05-07 Thread Alex Peshkoff via Firebird-devel
On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_time_zone in the attachment. For me such behavior looks suspicious (i.e. a bug to be precise). DefaultTimeZone set a

[Firebird-devel] DefaultTimeZone config

2021-05-06 Thread Adriano dos Santos Fernandes
Hi! Quoting README.time_zone.md: --- The session time zone, as the name implies, can be a different one for each database attachment. It can be set with the isc_dpb_session_time_zone DPB, and if not, it starts by default defined to be the `firebird.conf` parameter `DefaultTimeZone` or the sam