Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
Guten Tag Dalton Calford dalton.calf...@gmail.com [firebird-support], there is a free but limited version of ibexpert available which supports all current firebird versions http://www.ibexpert.net/ibe/ IBExpert Developer Studio Personal Edition > All the free firebird management tools are falling by the wayside. > Flamerobin can not handle the new datatypes, does not show database triggers, > crashes with UTF8 in many areas etc. > FenixSQL is dead > FirebirdWebAdmin is based on the no longer supported php5 > the list goes on. > Dbeaver is generic and is not well suited for Firebird > Overall, the loss of all these free administration tools stops people from > attempting to try firebird. > On Fri, 9 Nov 2018 at 09:49, jonatan.laurit...@yahoo.dk [firebird-support] > wrote: > > > > > > OK, there are multiple error reports in Flamerobin trackers about this and no > solution in more than 1.5 years. Flamerobin 9.2 works as expected, although > it does not support > internal functions, but such feature is not necesary for script execution.. > Apparently, Flamerobin is ceasing to exist. > DBveaver can be good replacement, but it has different convention for > scripts, e.g., it does not support multiple commit work; statements in the > script. > > > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Converting dates and the ISO-8601 format
Thanks very much Helen, a lot for me to digest here . Kind Regards,, Dave.
RE: [firebird-support] Converting dates and the ISO-8601 format
Yeah thanks Alan - I am currently using something similar.. extract(day from COLLECT_DELIVER_DATE)||'/'||extract(month from COLLECT_DELIVER_DATE)||'/'||extract(year from COLLECT_DELIVER_DATE) as COLLECT_DELIVER_DATE Just a bit "wordy" / "verbose" and a bit shocked that you have to go to those lengths to simply format a date field tbh As Helen suggests, I will ask in the PhP forum(s) and see if there is not some magic switch / setting that I am missing to do this "out of the box" or alternatively - a custom library perhaps (though I am loathe to introduce custom DLL;s as it complicates installation.) Thanks for the feedback.. Cheers!
RE: [firebird-support] Converting dates and the ISO-8601 format
>>I use Firebird primarily with Delphi and have had no problems with using and >>displaying dates >>(suitable for my country - UK.) You can use this in your select statements for php: f_dayofmonth(CREATEDATE)||'.'||f_month(CREATEDATE)||'.'||f_year(CREATEDATE) CREATEDATE format the PHP as you wish.
Re: [firebird-support] Converting dates and the ISO-8601 format
i...@synapsesoftware.co.uk wrote:
>I use Firebird primarily with Delphi and have had no problems with
>using and displaying dates (suitable for my country - UK.)
First thing to understand is that Firebird does not store dates
as strings. It can recognise string inputs for dates according to a
number of conventions but, at the back, it converts them to one or a
pair of numbers calculated from starting points on timescales.
What gets returned to the client when dates are read depends, as you
rightly guessed, on what the operating system is set up to display
and what the client interface offers for massaging date/time data
into strings. Most (if not all) Delphi interfaces use the Windows
regional settings.
>However, it seems to be a big problem with Firebird and dates when
>working with PhP with firebird driver. I have a number of fields that
>hold information in a field defined to be of type "date" in Firebird.
>When I use PhP to query my database I get the fields formatted in the
>ISO-8601 format (year/month/day.. etc).
Other than a UDF, there is nothing you can do in your SQL to influence
what string the client delivers to your interface. You should ask on the
firebird-php list for advice about this. PHP has so many little
functions to massage data that I'd be surprised if you didn't have
at least one convert option!
>I really dont know how to format the results so that they appear
>"normal" for my region - ie the dd/mm/ format. I also am not sure
>where the problem originates. It seems to depend on the client
>software I am using to view the data (which seems to imply its the
>client software that is responsible for rendering the data.)
True. Although there is the (not highly recommended) option of
using an external function ("UDF") to convert your dates to strings.
There are various UDF libraries around: look at
https://www.ibphoenix.com/download/tools/udf
for links to a selection of such libraries. You might find one that
does what you want. Of course, strings are not going to be a lot of
use to you if your applications want to do calculations on dates.
>Here is a summary of softwa re I have tried and the results
>Programresult
>FlameRobin Formatted correctly (except using the "." notation - so dd.mm.yy
Written in C++ using an interface called IBPP, which probably has a
function to massage dates into a format that is compatible with the
regional context of the host (or maybe the client).
>DBeaverFormatted incorrect for my region ( ISO-8601 format)
Depends on the driver you have behind this, I guess, and probably also
the regional settings on client or host or both. Firebird has lists
for both Java and ODBC/JDBC so it's worth asking on the appropriate
list.
>PhP Formatted incorrect for my region ( ISO-8601 format)
As above.
>Delphi (VCL) Formatted correctly dd/mm/
Follows the regional setting. This is easy to test.
>My question can be sumerised as - How to format the results so they
>are correct for a specific region (in this case the UK )? Should the
>client software (PhP/DBeaver etc) have a setting that allows you to
>format the results correctly ? Becasue I cant find any global setting
>in the various clients that will allow this.
>If we do have to explicitly cast / format the data - this adds a lot
>of work on the server / software and surely must have performance issues ?
Cast - no. But if you go the UDF route and export your dates as
strings then data over the wire will be fatter but work at the client
will be thinner. That's true of anything you convert, of course.
Can't avoid it.
>My goal is to format the result from a PhP request so the dates are
>displayed correclty. I understand that Firebird does not have
>the"convert" function - so I have tried using the "CAST t;
>function - but this seems to do very little
>
>for example..
>cast(TRANSDATE AS DATE) as TRANS_CREATED
>
>This seems to do nothing. I have tried looking through the PhP.ini
>file for some way to influence how the data is formatted and cannot
>find anything. I have even tried using ..
>
>ini_set('date.timezone', 'Europe/London');
>
>But this also did nothing.
I hope you understand a bit more now about what's going on in these
interfaces. Good luck.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
Re: [firebird-support] Firebird vs. PostgreSQL
2018-11-07 19:06 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > On 2018-11-07 16:28, Michal Kurczabinski michk...@gmail.com > [firebird-support] wrote: >> Firebird also doesn't support data partitioning, extended window >> functions > > What are you really missing in existing window functions support? > > Mark > First thought: range/rows between unbounded preceding and unbounded following / current row, etc.. own aggregate functions in conjunction with window functions, list(column) over ... Regards, Michał Kurczabiński
Re: [firebird-support] Converting dates and the ISO-8601 format
09.11.2018 13:38, i...@synapsesoftware.co.uk [firebird-support] wrote: > I really dont know how to format the results so that they appear "normal" for > my region - > ie the dd/mm/ format. I also am not sure where the problem originates. Formatting of dates is a client-side job. You should go to a PHP forum and ask there. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird vs. PostgreSQL
2018-11-07 16:33 GMT+01:00, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 07.11.2018 16:28, Michal Kurczabinski michk...@gmail.com [firebird-support] > wrote: >> Firebird also doesn't support data partitioning, extended window >> functions > >On the other hand transactions in PostgreSQL are strange: they > automatically rolled > back on any statement error. > > > -- >WBR, SD. > true thing ... -- Regards, Michał Kurczabiński
Re: [firebird-support] Re: Server crash when no more space for the database
2018. 11. 08. 12:40 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: > And I use web-interface for this group, surprise ? Vlad, I can send the attachment privately. Which address? Gabor ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
All the free firebird management tools are falling by the wayside. Flamerobin can not handle the new datatypes, does not show database triggers, crashes with UTF8 in many areas etc. FenixSQL is dead FirebirdWebAdmin is based on the no longer supported php5 the list goes on. Dbeaver is generic and is not well suited for Firebird Overall, the loss of all these free administration tools stops people from attempting to try firebird. On Fri, 9 Nov 2018 at 09:49, jonatan.laurit...@yahoo.dk [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > OK, there are multiple error reports in Flamerobin trackers about this and > no solution in more than 1.5 years. Flamerobin 9.2 works as expected, > although it does not support internal functions, but such feature is not > necesary for script execution. Apparently, Flamerobin is ceasing to exist.. > > DBveaver can be good replacement, but it has different convention for > scripts, e.g., it does not support multiple commit work; statements in the > script. > >
[firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
OK, there are multiple error reports in Flamerobin trackers about this and no solution in more than 1.5 years. Flamerobin 9.2 works as expected, although it does not support internal functions, but such feature is not necesary for script execution. Apparently, Flamerobin is ceasing to exist. DBveaver can be good replacement, but it has different convention for scripts, e.g., it does not support multiple commit work; statements in the script.
