On 11/06/2019 22:46, Vlad Khorsun wrote:
The simplest way would be to drop IDs and deliver to client only bias.
It is enough for all usages of timestamp with timezone I can think about.
I already offer to deliver to client both ID and displacement
(offset, bias)...
It costs nothing as cur
12.06.2019 0:23, Dimitry Sibiryakov wrote:
11.06.2019 21:52, Vlad Khorsun wrote:
I want to eliminate needs to translate something at client side.
The simplest way would be to drop IDs and deliver to client only bias. It is enough for all usages of timestamp with timezone I
can think about.
11.06.2019 21:52, Vlad Khorsun wrote:
I want to eliminate needs to translate something at client side.
The simplest way would be to drop IDs and deliver to client only bias. It is enough for
all usages of timestamp with timezone I can think about.
--
WBR, SD.
Firebird-Devel mailing li
11.06.2019 22:28, Adriano dos Santos Fernandes wrote:
On 11/06/2019 13:08, Vlad Khorsun wrote:
He may also do not use fbclient to format (convert from/to ts to string)
or convert (with/without timestamp) and uses others ways.
What other ways ? Nobody understand what is our region code.
W
On 11/06/2019 12:20, Adriano dos Santos Fernandes wrote:
> On 11/06/2019 12:13, Karol Bieniaszewski wrote:
as the field stores the UTC time
>>
>>
>> I know naive but..
>>
>> If conversion table is not available then if it is stored as utc why
>> not showing it as
>>
>> „15:09:49 UTC”?
>>
>>
On 11/06/2019 13:08, Vlad Khorsun wrote:
>> He may also do not use fbclient to format (convert from/to ts to string)
>> or convert (with/without timestamp) and uses others ways.
>
> What other ways ? Nobody understand what is our region code.
>
We can add API function to convert from/to ID/stri
On 11/06/2019 13:25, Vlad Khorsun wrote:
> 11.06.2019 18:13, Karol Bieniaszewski wrote:
>
>> PS. one more dll is not the problem for me, but maybe for others..
>
> 3 dlls and 1 dat file (~30MB in common), look at regular server
> distribution.
> Probably not all 3 dll's is required for TZ support
On 11/06/2019 17:25, Vlad Khorsun wrote:
Also, don't forget to update ICU data file on all clients. TZ
database is
changed often enough. For example, in 2018 there was 7 versions, see at
https://github.com/unicode-org/icu-data/tree/master/tzdata/icunew
Actually there were 9 releases ...
ht
11.06.2019 18:13, Karol Bieniaszewski wrote:
PS. one more dll is not the problem for me, but maybe for others..
3 dlls and 1 dat file (~30MB in common), look at regular server distribution.
Probably not all 3 dll's is required for TZ support, but the icudt63l.dat (26MB)
is needed.
Also, d
He may also do not use fbclient to format (convert from/to ts to string)
or convert (with/without timestamp) and uses others ways.
What other ways ? Nobody understand what is our region code.
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/f
On 11/06/2019 11:51, Dimitry Sibiryakov wrote:
> 11.06.2019 16:41, Paul Reeves wrote:
>> It seems to me that the implementation of CURRENT_TIME/STAMP is the
>> wrong way round. It should support the old behaviour.
>
> It does, but you must put "execute statement 'set time zone bind
> legacy'" int
On 11/06/2019 12:13, Karol Bieniaszewski wrote:
>
> >> as the field stores the UTC time
>
>
>
> I know naive but..
>
> If conversion table is not available then if it is stored as utc why
> not showing it as
>
> „15:09:49 UTC”?
>
>
>
> PS. one more dll is not the problem for me, but maybe for o
>> as the field stores the UTC time
I know naive but..
If conversion table is not available then if it is stored as utc why not
showing it as
„15:09:49 UTC”?
PS. one more dll is not the problem for me, but maybe for others..
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interf
On 11/06/2019 11:41, Paul Reeves wrote:
> On Tue, 11 Jun 2019 11:10:54 -0300
> Adriano dos Santos Fernandes wrote:
>
>> On 11/06/2019 11:08, Dimitry Sibiryakov wrote:
>>> 11.06.2019 15:41, liviuslivius wrote:
Can i ask what is the problem? When i retrive data by client lib it
try to co
11.06.2019 16:41, Paul Reeves wrote:
It seems to me that the implementation of CURRENT_TIME/STAMP is the
wrong way round. It should support the old behaviour.
It does, but you must put "execute statement 'set time zone bind legacy'" into ON
CONNECT trigger in every database.
--
WBR, SD.
On Tue, 11 Jun 2019 11:10:54 -0300
Adriano dos Santos Fernandes wrote:
> On 11/06/2019 11:08, Dimitry Sibiryakov wrote:
> > 11.06.2019 15:41, liviuslivius wrote:
> >> Can i ask what is the problem? When i retrive data by client lib it
> >> try to convert it to local timezone or what?
> >
> >
On 11/06/2019 11:22, liviuslivius wrote:
> >>from rdb$database - BOOM!
> But why is that boom?
> Why not show e.g.
> 11.06.2019 16:08 (GMT+01:00)?
>
> This does require some conversion? This is stored during save process.
>
>
if user uses +01:00 (offset) it should work. If user uses a region, it's
11.06.2019 16:22, liviuslivius wrote:
But why is that boom?
Why not show e.g.
11.06.2019 16:08 (GMT+01:00)?
a) Because server sends "timezone ID" instead of bias.
b) Because even if server sends bias, isql calls decodeTimestampTz() in any
case.
--
WBR, SD.
Firebird-Devel mailing list, web
On 11/06/2019 11:08, Dimitry Sibiryakov wrote:
> 11.06.2019 15:41, liviuslivius wrote:
>> Can i ask what is the problem? When i retrive data by client lib it
>> try to convert it to local timezone or what?
>
> Copy isql + fbclient.dll somewhere, connect to any database, select
> current_timestamp
>>from rdb$database - BOOM!But why is that boom?Why not show e.g.11.06.2019
>>16:08 (GMT+01:00)?This does require some conversion? This is stored during
>>save process.Regards,Karol Bieniaszewski
nullFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/fir
11.06.2019 15:30, Lester Caine wrote:
On 11/06/2019 12:32, Vlad Khorsun wrote:
One of "simple" solutions could be to ask sever once for whole conversion
table and to keep it at some temp file (or nearby fbclient\app) for future
usage.
It is also not ideal, as different servers could have dif
11.06.2019 16:45, Adriano dos Santos Fernandes wrote:
On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote:
What you mean by install?
Copy one .dll + .msg file is not install.
Copy more than one .dll + .msg file is install?
Adriano, users prefer to copy just one .dll (in many cases .
On 11/06/2019 11:08, Dimitry Sibiryakov wrote:
> 11.06.2019 15:41, liviuslivius wrote:
>> Can i ask what is the problem? When i retrive data by client lib it
>> try to convert it to local timezone or what?
>
> Copy isql + fbclient.dll somewhere, connect to any database, select
> current_timestamp
11.06.2019 15:41, liviuslivius wrote:
Can i ask what is the problem? When i retrive data by client lib it try to convert it to
local timezone or what?
Copy isql + fbclient.dll somewhere, connect to any database, select current_timestamp
from rdb$database - BOOM!
--
WBR, SD.
Firebird-D
Guys be patient ;-) deep breath..Can i ask what is the problem? When i retrive
data by client lib it try to convert it to local timezone or what? Is this the
same as formatting normal date field into user interface which should be on the
app side and we read only binary data? How it is done in o
On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote:
> What you mean by install?
>>
>> Copy one .dll + .msg file is not install.
>>
>> Copy more than one .dll + .msg file is install?
>
> Adriano, users prefer to copy just one .dll (in many cases .msg is not
> needed). Single file.
>
ICU in
11.06.2019 15:50, Adriano dos Santos Fernandes wrote:
On 11/06/2019 09:32, Vlad Khorsun wrote:
You trying to speculate on other issues to hide current one.
It will not work.
Issue will not disappear.
It's the same. You don't want to use icu DLL but use others DLLs that is
not always avail
On 11/06/2019 09:32, Vlad Khorsun wrote:
>
> You trying to speculate on other issues to hide current one.
> It will not work.
> Issue will not disappear.
>
It's the same. You don't want to use icu DLL but use others DLLs that is
not always available in Windows.
> So, all you can think on is
On 11/06/2019 12:32, Vlad Khorsun wrote:
One of "simple" solutions could be to ask sever once for whole
conversion
table and to keep it at some temp file (or nearby fbclient\app) for
future usage.
It is also not ideal, as different servers could have different ICU
versions, but
it could be
It seems you treat users as dumb and that they never change way to do
things and need to do the same thing they were doing in FB 1.5.
Just ask users, don't be shy.
Ok, but I myself had much more problems needing to installing CRTs
(sometimes more than one with snapshots) to run Firebird.
On 11.06.2019 14:47, Adriano dos Santos Fernandes wrote:
On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote:
What you mean by install?
Copy one .dll + .msg file is not install.
Copy more than one .dll + .msg file is install?
Adriano, users prefer to copy just one .dll (in many cases
On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote:
>> What you mean by install?
>>
>> Copy one .dll + .msg file is not install.
>>
>> Copy more than one .dll + .msg file is install?
>
> Adriano, users prefer to copy just one .dll (in many cases .msg is not
> needed). Single file.
>
At sa
On 11/06/2019 08:33, Vlad Khorsun wrote:
>>> This is pure demagogy. The problem is not what i like or not like.
>>> The problem is that your "software design" makes Firebird to be less
>>> and less attrictive for people. Small client with no need to install
>>> was a strong point of a Firebird f
On 11.06.2019 14:23, Adriano dos Santos Fernandes wrote:
On 11/06/2019 07:57, Vlad Khorsun wrote:
11.06.2019 13:34, Adriano dos Santos Fernandes wrote:
On 11/06/2019 03:56, Vlad Khorsun wrote:
11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
This is pure demagogy. The problem is not what i like or not like.
The problem is that your "software design" makes Firebird to be less
and less attrictive for people. Small client with no need to install
was a strong point of a Firebird for a long-long time. You going to
destroy it. We must fi
11.06.2019 1:41, Vlad Khorsun wrote:
06.03.2019 17:26, Adriano dos Santos Fernandes wrote:
On 04/03/2019 11:08, Adriano dos Santos Fernandes wrote:
On 04/03/2019 10:57, Alex Peshkoff via Firebird-devel wrote:
On 3/4/19 3:15 PM, Vlad Khorsun wrote:
04.03.2019 14:01, Alex Peshkoff via Firebird-
On 11/06/2019 07:57, Vlad Khorsun wrote:
> 11.06.2019 13:34, Adriano dos Santos Fernandes wrote:
>> On 11/06/2019 03:56, Vlad Khorsun wrote:
>>> 11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
Vlad, first of all, please say
11.06.2019 13:34, Adriano dos Santos Fernandes wrote:
On 11/06/2019 03:56, Vlad Khorsun wrote:
11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
Vlad, first of all, please say me what's the difference with Linux
fbclient that has libtommath as d
On 11/06/2019 03:56, Vlad Khorsun wrote:
> 11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
>> On 10/06/2019 19:41, Vlad Khorsun wrote:
>>
>> ...
>>
>> Vlad, first of all, please say me what's the difference with Linux
>> fbclient that has libtommath as dependency since v3.
>
> I don't know.
11.06.2019 12:44, Alex Peshkoff via Firebird-devel wrote:
On 11.06.2019 1:41, Vlad Khorsun wrote:
Do this 2 facts
- client have some ICU library, but it can't convert region ID obtained from
server (because of different ICU version), or even
- wrong conversion of region ID at client side bec
11.06.2019 11:44, Alex Peshkoff via Firebird-devel wrote:
If different ICUs have different ID for same TZ than:
- ID should be extended with ICU version,
- suggested by Vlad table should have ICU version in the header. Yes, client will store >1
copies of that table if it connects to different se
On 11.06.2019 1:41, Vlad Khorsun wrote:
Do this 2 facts
- client have some ICU library, but it can't convert region ID
obtained from
server (because of different ICU version), or even
- wrong conversion of region ID at client side because of mismatched ICU
version (sounds impossible, but n
Inconsistent RDB$COLLATION_ID when restoring from 2.5 to 3.0 for same UDF
-
Key: CORE-6081
URL: http://tracker.firebirdsql.org/browse/CORE-6081
Project: Firebird Core
Is
On 11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
Vlad, first of all, please say me what's the difference with Linux
fbclient that has libtommath as dependency since v3.
I suppose main difference is that linux pure-client installation is
som
44 matches
Mail list logo