Re: [Firebird-devel] R: List of keywords?

2011-05-03 Thread Lester Caine
as well as the newer MySQL and PostgreSQL status. -- 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

Re: [Firebird-devel] url from headers

2011-08-23 Thread Lester Caine
changing it is appropriate as long as the target actually has license information. -- 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] url from headers

2011-08-23 Thread Lester Caine
released - thats how they stay. Did Inprise exist when the files were originally released? That was changed later already wasn't it? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve

Re: [Firebird-devel] Choosing a distributed version control system for firebird project

2011-08-25 Thread Lester Caine
as nothing is done that actually blocks other DVCS systems working in parallel it's not a problem, but some git repo's are simply impractical to use any other way :( https://wiki.php.net/rfc/dvcs/vote Unfortunately I don't have enough brownie points to support hg there. -- Lester Caine - G8HFL

Re: [Firebird-devel] news from kernel 3.1

2011-10-26 Thread Lester Caine
stacks' on the same hardware. I'm seeing W7 setup 4 times slower than the same stack running on SUSE 11.4 which is dual boot installed on the same machine. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-01 Thread Lester Caine
: - DBA with brain is required. ... Requires a downtime? Which can be substantial Unless the configuration can be set up to allow updates applied following the backup-restore cycle to be reapplied? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-02 Thread Lester Caine
of time is simply not practical in a lot of cases, so we need to be able to manage how things are handled during any maintenance cycle. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-02 Thread Lester Caine
for maintenance reasons. -- 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// Firebird - http

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-02 Thread Lester Caine
in the past, so nowadays it's a lot more reliable to have simple duplicate machines on the system each capable of providing the services needed. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Lester Caine
. -- 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 - http

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Lester Caine
to the client and type in data. A one hour interview results in a few seconds of data to save. Oh for the days when I NEED a networked database ... Perhaps I'll start earning some money as well :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-17 Thread Lester Caine
a clean prefix that can be searched for where symlinks ARE still supporting the old style simply begs that the same prefix is maintained? (long gone are the days of 8.3 filenames) They are still present in FAT based storage ... -- Lester Caine - G8HFL - Contact

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-19 Thread Lester Caine
. And if you don't stop access to the database it gets screwed up :( Just been hit by that one on a big site, but it's running on Firebird now :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk

Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout

2013-01-11 Thread Lester Caine
it to work on Linux but probably due to coming from a windows background? -- 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

Re: [Firebird-devel] (Double) Metaphone?

2013-04-04 Thread Lester Caine
Wols Lists wrote: On 03/04/13 12:12, Lester Caine wrote: Kjell Rilbe wrote: So, to be frank I'd say for many languages the problem is not if FB has support for phonetic matching or not, but if a working phonetic matching algorithm even exists (has been developed) for that language

Re: [Firebird-devel] FWD: Re: Compatibility FB3.0 boolean and Interbase

2013-11-13 Thread Lester Caine
maintaing compatibility with other working systems. At least I no longer have any Interbase systems live these days :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http

[Firebird-devel] ICU configuration

2014-02-27 Thread Lester Caine
as long as I can simply store UTF-8 data IN the database so I've not taken much notice of the debate in this area, but I assume there has been a similar one here? ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services

Re: [Firebird-devel] ICU configuration

2014-02-27 Thread Lester Caine
, and the U_CHARSET_IS_UTF8 flag is something that needs to be changed across many projects. -- 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] ICU configuration

2014-02-27 Thread Lester Caine
and I think Firebird is already handling that somehow? FB3 is something I'd like to dovetail into PHP6 cleanly even if I only need to use Unicode for content. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services

Re: [Firebird-devel] MySQL versus Firebird

2014-03-11 Thread Lester Caine
marius adrian popa wrote: I needed comments from developers also And developers don't read firebird-general? What is more irritating is seeing the same stuff over and over again! -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [Firebird-devel] libfbembed.so static for android

2014-03-26 Thread Lester Caine
Alex Peshkoff wrote: On 03/25/14 19:01, Lester Caine wrote: Dalton Calford wrote: My quad core, 1.7 ghz 2 GB ram/32 GB storage phone, is more powerful than our scp systems which have been processing millions of customer calls in real time over the past 14 years. Android also runs

Re: [Firebird-devel] New Interface

2014-08-13 Thread Lester Caine
or need the hassle of upgrading. What is so pressing that we need this new interface anyway? What we already have is still better than some of the alternatives and I'm still moving data off MySQL and other platforms to Firebird ... -- Lester Caine - G8HFL - Contact

Re: [Firebird-devel] Coding style: one-line blocks

2014-09-02 Thread Lester Caine
On 02/09/14 16:00, Mark Rotteveel wrote: Braces around single statements would have made this bug less likely. Have made many bugs less likely ... It's not 'dangerous' just a little more error prone. My IDE code completion is set to add the braces on every language. -- Lester Caine - G8HFL

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Lester Caine
:( -- 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 - http://rainbowdigitalmedia.co.uk

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Lester Caine
for the DVCS local clones of different branches, but a useful backup that avoids the need to create extra clones most of the time. BC also has a nice three way mode when trying to merge local changes with the base code and other peoples pushes. -- Lester Caine - G8HFL

[Firebird-devel] Status of SQLCODE

2016-02-24 Thread Lester Caine
/reference_manuals/fblangref25-en/html/fblangref25-appx02-sqlcodes.html and it's 'note' is a little concerning when the SQLCODE is used by many third party interfaces. SO what are the current plans on this? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact

Re: [Firebird-devel] Status of SQLCODE

2016-02-24 Thread Lester Caine
nslations. Which is where we are at in the ADOdb driver. However that does already have a short version of the SQLSTATE list in the oracle error code array. I think the starting point is probably the PHP driver to switch it to returning SQLSTATE and perhaps gdscode ? -- Lester Caine - G8HFL

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

2016-02-29 Thread Lester Caine
ll it detract from the same functions working across all OS's ? That M$ seems to break perfectly functional code at every compiler upgrade is the agro, and is there no way to mitigate that by some 'bc fix' file? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wik

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

2016-03-11 Thread Lester Caine
r 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.co.uk EnquirySolve

Re: [Firebird-devel] GitHub

2016-03-14 Thread Lester Caine
lly. 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 current work flows forced on us by git?

Re: [Firebird-devel] GitHub

2016-03-15 Thread Lester Caine
ubmodules 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.com/ Model Engineer

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

2016-03-14 Thread Lester Caine
293/ 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] RFC: File names with non-ASCII non-ANSI letters

2016-03-16 Thread Lester Caine
t 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 a different way

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

2016-03-19 Thread Lester Caine
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 anyway so perhaps we have to live with that? :( -- Lester Cain

Re: [Firebird-devel] Git

2016-03-20 Thread Lester Caine
m *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 - G8HFL - Contact - http://lsces.

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

2016-03-08 Thread Lester Caine
On 08/03/16 17:00, Dmitry Yemanov wrote: > 08.03.2016 19:06, Dimitry Sibiryakov wrote: > >> 05.03.2016 22:28, Lester Caine wrote: >>> It would be nice if we did not have re-order scripts from other >>> databases so >>>NOT NULL DEFAULT '30' >

Re: [Firebird-devel] RFC: Tablespaces

2016-03-04 Thread Lester Caine
ough if necessary? What gets my goat currently is the way my bank 'archives' the on-line data to bank statements so one can't easily scroll back, but each of those 'blob's of data could be made accessable with a different approach to the storage? -- Lester Caine - G8HFL ---

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

2016-03-05 Thread Lester Caine
e days where an abstraction of some sort is used. ADOdb we can ensure the 'datadict' or 'XML' scripts produce the right order, but where initialise scripts use raw SQL it's a difficult one to modify on the fly. -- Lester Caine - G8HFL - Contact - http://lsces.co.u

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

2016-03-06 Thread Lester Caine
ion. And this is what Firebird does. The syntax in the SQL > Standard is defined as: Ta ... I knew there was a reason ... but I did my talks on inter database operability at the conferences 10 years ago :) But I doubt that MySQL and Postgresql will fix that now :(

Re: [Firebird-devel] GitHub

2016-03-02 Thread Lester Caine
ust which compiler, package handler and build process should one be using :( -- 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 Works

Re: [Firebird-devel] Core-1686

2016-03-02 Thread Lester Caine
ted from the current code base. Producing something along those lines is probably a useful starting point and will help others as well. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquiryS

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
LL 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 - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://

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
ly' 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=contact L.S.C

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-27 Thread Lester Caine
be managed specifically, and leaving these as 'null' values without the 'NOT NULL' constraint would perhaps be appropriate for this business logic? Rather than some hidden mechanism that distinguishes different versions of the same record? -- Lester Caine - G8HFL - Contact - h

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
e 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 EnquirySolve - http

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

2017-12-15 Thread Lester Caine
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/?page=contact L.S.Caine Electronic Services - http

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

2017-12-15 Thread Lester Caine
ber of PHP software packages when PHP introduced TZ and ran it from the browser offset! The DATABASE needs to know what the rules are and it is simple to define them as offsets, but personally I don't think that solves anything. It just makes things worse. An offset timestamp is NOT usable timezone

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 Caine -

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

2017-11-21 Thread Lester Caine
a 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 Digital

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-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 'sol

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

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
and TSDist would then provide patch updates to that data without needing to retransmit the whole TZ database every time! -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http

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

2018-05-10 Thread Lester Caine
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/ Model

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

2018-05-10 Thread Lester Caine
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 - http://lsces.co.uk

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

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

2018-05-10 Thread Lester Caine
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. -- Lester Caine - G8HFL --

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

2018-05-10 Thread Lester Caine
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 Engineers Digital Workshop

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

2018-05-10 Thread Lester Caine
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 - Contact

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

2018-05-10 Thread Lester Caine
d 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.co.uk EnquirySo

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Lester Caine
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/?page=contact L.S.Caine Electronic

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 EnquirySolve - http

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

2018-05-13 Thread Lester Caine
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://medw.co.uk Rainbow Digital

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

[Firebird-devel] Problems with Timezone adjusted data

2018-05-11 Thread Lester Caine
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 data. -- Lester Caine - G8HFL

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

2018-05-11 Thread Lester Caine
is that 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 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

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] Time zone feature documentation

2018-05-11 Thread Lester Caine
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 Electronic Services - http://lsces.co.uk EnquirySolve - http

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
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 - Contact - http://lsces.co.uk

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

2018-05-15 Thread Lester Caine
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 Digital Media - http

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
e 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 EnquirySo

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-03 Thread Lester Caine
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 Digital Workshop - http://medw.co.uk Rainbow Digital Media

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
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 Services - http://lsces.co.uk

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 rule itself

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
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://medw.co.uk Rainbow

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Lester Caine
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 - Contact - http://lsces.co.uk/wiki/?page

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
ables 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't know what the original data was ... --

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Lester Caine
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 - Contact - http://lsces.co.uk

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 Works

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] Valid date or not

2018-02-28 Thread Lester Caine
if 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
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 Services - http://lsces.co.uk EnquirySolve - http

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 it's use

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

2018-10-26 Thread Lester Caine
. -- 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.co.uk

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] LOCALTIMESTAMP name

2018-10-23 Thread Lester Caine
AMP 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] Difference in performance between current_timestamp and localtimestamp

2018-12-29 Thread Lester Caine
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 Media - https

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] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-26 Thread Lester Caine
m 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 - Contact - https://lsces.

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

2019-03-04 Thread Lester Caine
referenced 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 ... -- Lester Cai

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

2019-03-04 Thread Lester Caine
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 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
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 - https://enquirysolve.com/ Model Engineers

[Firebird-devel] Stable distributions ...

2019-02-25 Thread Lester Caine
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://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic

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

2019-02-25 Thread Lester Caine
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 problems. -- Lester Caine

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
.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 L.S.Caine

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

2019-03-04 Thread Lester Caine
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 easier. -- Lester Caine - G8HFL

  1   2   >