Re: [Firebird-devel] Timezone IDs in Firebird

2020-12-14 Thread Lester Caine
e ID's simply select a data set that matches post 1970 rather than one that actually matches the fully validated pre-1970 data so again some timezone ID's simply return poor information where their being removed would be a safer approach ... the whole system is still

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Lester Caine
ield identifying the correct local location. -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - https://medw.uk Rainbow Digital Media - https://rainbowdigitalmedia.uk

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-08 Thread Lester Caine
DST management simply because it was too difficult to include. -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - https://medw.uk Rainbow Digital Media - https

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-17 Thread Lester Caine
wait until some of the higher level facilities decide on a new language before doing anything. github will be changing and there is no point trying to push something different to their 'dictates' even if there is no complete agreement on what 'it' deci

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

2020-06-03 Thread Lester Caine
nk I could see earlier ... and I have corrected that ... -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - https://medw.uk Rainbow Digital Media - https://rainbow

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

2020-06-03 Thread Lester Caine
more difficult to navigate ... Linking to github in discussions does not always produce the same document even ignoring the fact that these documents will be evolving, so it is important to have a set of non-github documentation sooner rather than later. -- Lester Caine -

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

2020-06-03 Thread Lester Caine
On 03/06/2020 08:23, Lester Caine wrote: On 02/06/2020 22:17, Dimitry Sibiryakov wrote: 02.06.2020 21:45, Mark Rotteveel wrote: I think that is extremely confusing, and not acceptable.    That's why everyone was given several years to replace CURRENT_TIME with LOCALTIME and don'

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

2020-06-03 Thread Lester Caine
d handling CLIENT local times is an interface problem and not something which should be inconsistent in the core data ... especially when one does not know what future time offsets will actually be ... -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Lester Caine
an be found in the development repository https://github.com/eggert/tz -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - https://medw.uk Rainbow Digital Media -

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Lester Caine
tz data used to provide that normalization! The FB4 'timezone' is yet another unreliable data source! And this is the same for historic data and published calendars for the coming 6 months ... -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Cain

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Lester Caine
ning about not using this with pre 1970 dates -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - https://medw.uk Rainbow Digital Media - https://rainbowdigitalmedia.uk Fi

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6276) Conversion from WITH TIME ZONE to WITHOUT TIME ZONE types should drop the time zone instead of use the session time zone

2020-04-05 Thread Lester Caine
The fact that the TZ database also drops validated rule changes prior to 1970 is another critical element here ... ) -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Workshop - htt

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

2020-03-06 Thread Lester Caine
acy as provided by the TZ database it is already broken ... At least the documentation should point out the limitations of the crude shortcut that as been adopted ... -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - h

Re: [Firebird-devel] Web site cert issue

2020-02-14 Thread Lester Caine
ll of open data, but things have progressed to a point where NOT using HTTPS is virtually impossible without other agro. That said, letsencrypt can't be relied on to complete a renewal cycle ... I've just had manually clean up some certs myself so you have to keep on top of every one

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Lester Caine
well by any of the current TZ offerings. That is where a TZ identifier to go with the time is important and the simple 'offset' has never worked. -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-07-13 Thread Lester Caine
fixes very little but adds more things to be patched by real applications ... Timezone data has a one second accuracy and MANY edge cases will hit that so anything built in must be able to process that data! Simply pull it all until a full solution can be addressed! -- Lester Caine - G8HFL

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-14 Thread Lester Caine
time zone 101 20+ years ago and nothing has changed since ... if you ONLY want local time then just use that instead of UTC and ignore the DST overlap problems. -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https:

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-14 Thread Lester Caine
World War 2 archival material can not reliably use the rules supplied because different systems may not have the proper pre-1970 data :( We do not actually have any indication if the rule set is valid pre-1970. This is a basic implementation detail for any system trying to use TZ data :( -- L

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-11 Thread Lester Caine
same discussion is in part being had about the Java timezone handling ... there is no consensus on how it should be done! -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Services - https://lsces.uk Model Engineers Digital Wor

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-11 Thread Lester Caine
eases ... https://data.iana.org/time-zones/ and the current development release is at https://github.com/eggert/tz which has tz changes that have not yet been publicly released. -- Lester Caine - G8HFL - Contact - https://lsces.uk/wiki/Contact L.S.Caine Electronic Ser

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Lester Caine
y to when processing the data, so we need access to ALL the historic changes to the rules or at least a copy of the rules used to store data and the current rules with some mechanism to update that data ... -- Lester Caine - G8HFL - Contact - https://lsces.uk/wik

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

2019-04-24 Thread Lester Caine
y updating the rules without any warning causes all sorts of problems? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digi

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

2019-04-23 Thread Lester Caine
TZ is simply not the solution for most cases - current day or historic ... and the further restrictions FB4 introduces just makes matters worse! -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.

Re: [Firebird-devel] [PHP-DEV] [RFC] Unbundle ext/interbase

2019-03-22 Thread Lester Caine
MySQL situations a few times in the last year! So all we are asking for is HELP with the code changes that result from changes to the PHP API to keep this available. -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services

Re: [Firebird-devel] Timezone id in big endian clients?

2019-03-04 Thread Lester Caine
wire is perhaps another reason that simply making it natively work with second accuracy rather than minute would have been a step in the right direction? At least that would be more compatible with some of the other approaches and make cross working a little eas

Re: [Firebird-devel] Timezone id in big endian clients?

2019-03-04 Thread Lester Caine
fails if the TZ data changes between storing the offset time and reading it. -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Di

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-03-04 Thread Lester Caine
ferenced and in the absence of anything else this has to be the server. That is until such time as we can rely on the local source being able to reliably identify it's provenance. The VERSION of TZ data being used is an essential element that currently is a complete gamble ... --

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-26 Thread Lester Caine
based tuner ... it can be a problem at times when one changes something working out just which bit HAS broken ... thg is also up and working again after rolling back to an older build that matches the available hggit ... so now to add some new code! ) -- Lester Caine - G8HFL ---

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-25 Thread Lester Caine
NK has a change? UserManager = Legacy_UserManager I think had the ", Srp" in the earlier version and it's that which I was adding back first ... leaving it out THEN AuthServer = Legacy_Auth, Srp is not causing a problem! Now back to trying to find out why streaming video is brok

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-25 Thread Lester Caine
PHP, so DO I need to worry about SRP on this setup? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://

Re: [Firebird-devel] Stable distributions ...

2019-02-25 Thread Lester Caine
windows machine just to get something working for now but all I've been doing for the last week is trying to get a stable development platform again ... however just had another report of a problem on a client website so need to fix that ... sites that have run for years without any problem

[Firebird-devel] Stable distributions ...

2019-02-25 Thread Lester Caine
s that avoid the new bits in FB3 but with FB4 now appearing there is a further minefield on the horizon with timezone management hand grenades on the side! So just where DO I start trying to get back to a stable platform? -- Lester Caine - G8HFL - Contact - https://l

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-23 Thread Lester Caine
l network link and I don't need any more than that so why should I have to do any more than getting a single user working? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - h

Re: [Firebird-devel] Setting time zone bind through DPB?

2019-02-23 Thread Lester Caine
pre-1970 data, but there is no way currently of distributing this material :( -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-23 Thread Lester Caine
acy_UserManager, Srp WireCrypt = Disabled And I am connecting and working ... AVOIDING following the Compatibility chapter ... so where am I going wrong? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services -

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-23 Thread Lester Caine
g FB2.x and FB3 systems in parallel? Certainly I've had to strip everything but Legacy_Auth and Legacy_UserManager in order to get my PHP setups to run with FB3! So is FB4 any different? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Lester Caine
machines on the network. -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Lester Caine
as well? Is it better to keep specialist elements like databases on their own drives? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engi

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-21 Thread Lester Caine
18i was released on the 31st December, but there is no way of ensuring that the data you are using currently will match that which the OS is working with tomorrow! This method of working with timezones was not thought out at all and is why FB4 timezone handling is badly broken! -- Lester Ca

Re: [Firebird-devel] Difference in performance between current_timestamp and localtimestamp

2018-12-29 Thread Lester Caine
sets to be used for everything? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Med

Re: [Firebird-devel] Status of time zone support

2018-10-26 Thread Lester Caine
On 26/10/2018 16:18, Adriano dos Santos Fernandes wrote: On 26/10/2018 12:01, Lester Caine wrote: On 26/10/2018 14:53, Dmitry Yemanov wrote: Yes, it gonna be merged from PR soon.     What is the status for time zone support? Is it going to be included in     Firebird 4 or not? But the very

Re: [Firebird-devel] Status of time zone support

2018-10-26 Thread Lester Caine
data. -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Lester Caine
became the standard some time back but there will still be pockets of users who split it ... but certainly LOCAL_TIMESTAMP makes a lot more sense as a result :( -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Servic

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
ithin Firebird. Ideally we need 'next' outside of Firebird. There are some places where 'between' works and others where 'gt/lt' IS the correct process in order to remove problems cause by differing precision settings. -- Lester Caine - G8HFL ---

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
t ... no need to populate vast tables of transitions ... This is useful where you have more than one set of rules so you can select the right version when processing and upgrade to a new version ... If you update the table of transitions before establishing if any data needs amending you don

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
es the rule set and creates what is needed on the fly. And for the majority of non-dst timezones the rule is the transition ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk Enqu

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
a more accurate setup than any of the other engines ... and adding the geolocation element even helps get the calendar right. The fact that we use 'day.time' natively already makes Firebird ideal for sorting a lot more than just timezone! -- Lester Caine - G8HFL --

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
should at least be capable of the same level of accuracy. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://med

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
On 05/06/18 09:39, Mark Rotteveel wrote: On 5-6-2018 10:16, Lester Caine wrote: On 05/06/18 08:50, Mark Rotteveel wrote: That naming doesn't make much sense to me, and I actually found the RULE_START and RULE_END naming pretty clear and self-explanatory. Except that it's not the r

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
s on the rules currently while they put TZIF into a formal RFC standard. These standards are not ideal but do provide a common set of rules such as names of fields ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-03 Thread Lester Caine
date' the limited format that is proposed here is designed to be used from. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Dig

Re: [Firebird-devel] Virtual table for time zones

2018-05-15 Thread Lester Caine
used in several timezone rule sets. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digit

Re: [Firebird-devel] Virtual table for time zones

2018-05-14 Thread Lester Caine
locally cached data from that. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media

Re: [Firebird-devel] Virtual table for time zones

2018-05-14 Thread Lester Caine
possibility Lester could add missed historical rules, i think. One of the items on my back burner is a Firebird powered TZDist service which would provide versioned sets of rules and the check facility for individual timezones. The data would simply be a Firebird database ... The problem as always

Re: [Firebird-devel] Virtual table for time zones

2018-05-14 Thread Lester Caine
as if TZ add new timezones how are the ones hard coded in Firebird updated ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital

[Firebird-devel] Firebird's compatibility with real world.

2018-05-13 Thread Lester Caine
reciate the details and I welcome any contributions to site! -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://m

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Lester Caine
databases 'solutions' as well. As it currently stands it's no use to my applications so no reason to even bother testing it ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk Enqu

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Lester Caine
on 'internet devices'. I have also been advised of a new ietf task group to address the Geolocate Extension and the Time Zone Information Format bu these will be some time reaching an RFC stage :( -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 12/05/18 00:32, Adriano dos Santos Fernandes wrote: On 11/05/2018 19:48, Lester Caine wrote: There is no information on those pages covering just what way the base TZ data is processed. I think it is probably safe to assume that it is unusable for providing timezone offsets prior to 1970

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 11/05/18 23:32, Vlad Khorsun via Firebird-devel wrote: 12.05.2018 1:12, Lester Caine wrote: On 11/05/18 20:37, Adriano dos Santos Fernandes wrote: * PST is Pitcairn or Pacific, with the same offset, they are considered different time zones ICU data is derived from TZ data hosted by IANA

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
est 'IST' is used by them for India Standard Time but it would be nice if there was an easy way to confirm that? Certainly I'm not seeing data in zoneinfo64.txt for Isle of man, Jersey, Guernsey or Belfast so I suspect they are not valid pre-1970 :( -- Lester Caine - G8HFL

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
ve not seen it. It provides nice tidy definitions of many of the key terms. It also fails to define just how time zone names are created3 leaving that to the 'publisher'. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
On 11/05/18 16:07, Adriano dos Santos Fernandes wrote: On 11/05/2018 11:55, Lester Caine wrote: On 11/05/18 15:44, Adriano dos Santos Fernandes wrote: If the machine clock goes back one hour because of a DST transition, the current time overlaps and the same set of numbers are used twice. No

Re: [Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
they use a simple TIMESTAMP where possible and add the timezone information outside of the stored data. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com

Re: [Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
On 11/05/18 14:27, Adriano dos Santos Fernandes wrote: On 11/05/2018 10:10, Lester Caine wrote: Forgot to hit reply list ... On 11/05/18 12:30, Adriano dos Santos Fernandes wrote: On 11/05/2018 06:54, Lester Caine wrote: I was having a proper look through the Oracle timezone documentation

Re: [Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
Forgot to hit reply list ... On 11/05/18 12:30, Adriano dos Santos Fernandes wrote: On 11/05/2018 06:54, Lester Caine wrote: I was having a proper look through the Oracle timezone documentation and thinking 'how can you get it so wrong'. Does it REALLY have a ERROR_ON_OVERLAP_TIME fl

[Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
s will affect any current data sets world wide, there are many people working through paper archives just like P Chan has done for Macau to correct the historic rule sets so once a system is in place that ALLOWS easy normalization of data it should protect the integrity of that d

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
ssing valid backzone id's and even some main list entries! The versioning only seems to affect the format of the iles, not the content. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
are only a very small number of changes to the rule sets each year, but they are likely to affect current stored data. Simply pretending the problem does not exist - as other databases do - should not be acceptable these days. -- Lester Caine - G8HFL - Contact

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
rrectly - to describe the offset and not the set of rules plotting the changes to the offset. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model E

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
used to create the 'international' timetable when local DST times are changed at short notice ... TZDist is intended to prevent this problem, but since there are no active sources we are still stuck with the miss-match of data between different OS's and system. -- Leste

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
he southern hemisphere is reversed and Australian abbreviations don't follow the same guide. Some tools could not handle the -ve DST so it's implementation has been delayed, but the plan is that the correct data will be provided by TZ at least in future. -- Lester Caine - G8HFL --

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
one' contains a number of historic abbreviations some of which were inventions and should be ignored, and others are pre 1970 so not visible in some instances. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
On 10/05/18 17:12, Vlad Khorsun via Firebird-devel wrote: 10.05.2018 19:02, Adriano dos Santos Fernandes wrote: On 10/05/2018 12:53, Lester Caine wrote: ... And how will the version of TZ data be handled! This is a key element that has screwed normalized data in the past, and some way to

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Lester Caine
data in the past, and some way to manage that normalized data needs to be included in the process. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/

Re: [Firebird-devel] Time zones

2018-05-02 Thread Lester Caine
On 02/05/18 20:22, Adriano dos Santos Fernandes wrote: On 02/05/2018 13:16, Lester Caine wrote: On 29/04/18 21:47, Adriano dos Santos Fernandes wrote: But standard CURRENT_TIME and CURRENT_TIMESTAMP  works different than Firebird, as they returns the "WITH TIME ZONE" types.

Re: [Firebird-devel] Time zones

2018-05-02 Thread Lester Caine
local time indication. I don't want CURRENT_TIME to be loaded with a timezone. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Lester Caine
required then convert TO this format. This SHOULD be the default and anything else converts from it. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Lester Caine
On 28/02/18 10:29, Mark Rotteveel wrote: On 28-2-2018 10:54, Lester Caine wrote: Technically, the SQL Standard knows only one format, and that is (slightly simplified): -MM-DD HH24:MI:SS.FF..+/-TZH:TZHM While this is the 'standard' it has the same fundamental flaw that i

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Lester Caine
ly more complex problem than month text handling especially since even the TZ database can't agree on just what text to use. The only thing that is consistent is Time OFFSET which uses the '-' sign anyway as a flag. A '+' or '-', not just a '-'. My p

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Lester Caine
ly since even the TZ database can't agree on just what text to use. The only thing that is consistent is Time OFFSET which uses the '-' sign anyway as a flag. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-15 Thread Lester Caine
On 15/12/17 15:41, Leyne, Sean wrote: > Lester > >> The problem I had in the past was with meetings being moved over a DST >> boundary. And this was in a SINGLE timezone. The software was normalizing >> everything to UTC time, so that it could be displayed in local time of

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-15 Thread Lester Caine
'time-zoned', one needs to properly manage the timezone information and store the identity of the information used to create the offset! Anything else should not be called 'time-zoned' ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-12 Thread Lester Caine
ated when in reality only one or two rules may have changed. The VERSION of TZ data that was used to normalize the UTC timestamps is just as important as the location of the event. The two go hand in hand ... and it's the version data that is missing in the Oracle

Re: [Firebird-devel] Support for timed-zones datatypes

2017-11-21 Thread Lester Caine
On 21/11/17 18:31, Mark Rotteveel wrote: > On 2017-11-21 18:31, Lester Caine wrote: >> On 21/11/17 16:42, Mark Rotteveel wrote: >>> >>> If you need that, you also need to store the actual timezone somewhere. >>> PostgreSQL for example also uses an offset for t

Re: [Firebird-devel] Support for timed-zones datatypes

2017-11-21 Thread Lester Caine
g data from other databases. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Dig

Re: [Firebird-devel] Support for timed-zones datatypes

2017-11-21 Thread Lester Caine
e when large areas of the planet still use daylight saving. If I move a meeting from March to April I need to know the real timezone, a simple hour offset is no good at all. It's the same old problem as the offset provided by a browser ... useless for half of the year ... -- Lester Ca

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-27 Thread Lester Caine
lly implied by the use of the COMMIT without any other action. If you have some reason to distinguish between the older records and the 'XYZ' default records, then this should be managed specifically, and leaving these as 'null' values without the 'NOT NULL' constrain

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-24 Thread Lester Caine
On 24/03/17 21:42, Vlad Khorsun wrote: > 24.03.2017 21:36, Lester Caine wrote: >> On 24/03/17 17:57, Vlad Khorsun wrote: >>>> What must be done is specified exactly. And we should suppose that in >>>> all other aspects data stored in database should not be chan

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-24 Thread Lester Caine
gically' and the SQL spec does not override that basic function of a value in an existing record? The DEFAULT value should only be used to replace a NULL value when a record is added ... full stop. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=con

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-24 Thread Lester Caine
ATE of some type. Certainly if a default value is a time stamp then it is no different to a fixed default value once a new record is added. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk Enqu

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-24 Thread Lester Caine
that actually stored, then I would say THAT is a bug. If the stored field is NULL then either the query should return that or contain the logic to display it as something else, it should not be 'magic' depending on some other settings? -- Lester Caine - G8HFL ---

Re: [Firebird-devel] Git

2016-03-20 Thread Lester Caine
Working on a single target program *IS* a lot easier than some of the projects that I'm working with, but having a clean base to build on is essential? And as I understand it, having one 'release manager' controlling the 'master' code branch is sensible? -- Lester Caine -

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-19 Thread Lester Caine
x27; things we have to put up with with. That SQL and other programming languages are essentially 'english' is not real case for only supporting 'english' in the 21st century? But many programming languages and os's still can't cope with this problem anyw

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-16 Thread Lester Caine
ind it strange that people still use OS specific settings on networked systems which could well have problems with that. None of my users even know that it's Firebird providing the grunt, as the hack attempts attest, so shouldn't the inter OS conversion problems be handled in

Re: [Firebird-devel] GitHub

2016-03-15 Thread Lester Caine
with the selected submodules being a particular snapshot, rather than an active element you can update. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-14 Thread Lester Caine
/ refers to the same link and does not require you to log in. Seems any work by michkap has now been wiped? As a result one gets redirected to the login screen. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http

Re: [Firebird-devel] GitHub

2016-03-14 Thread Lester Caine
is synced and track individually. Anybody remember the good old days when one could hit 'sync' and see which blocks of code had been updated ... one could then simply merge a block or individually scan the files of a block you were also working on. Not something that is easy to do with the

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-11 Thread Lester Caine
ll lower case, but it was a windows application that transferred the files and I've seen similar problems several times on cross OS sites! -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-11 Thread Lester Caine
27;s the switch to windows UTF-16 transcoding which is the problem we find in PHP. I thought there WAS a simplification in the process that Windows uses? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http:

  1   2   >