Re: [firebird-support] Firebird 3 PSQL Features

[rgilland1...@gmail.com [firebird-support]]

OK, just read through all the examples and release notes, of the latest 
Firebird 3 beta, Looks like, plugging in of other languages, is done in the 
"plug-in" engine area.
 There are no samples of Delphi/FPC headers yet for this, although it is 
promised, I hope this does not get forgotten.
 This seems to be a great and much welcomed improvement on the UDF style of 
external functionality.
 

 I guess what I was looking for was someway within firebird of declaring 
classes/types/variables of these classes.
 So that, as in a normal Object Oriented Programming environment, it is 
possible to pass these complex structures as containers around. I did look into 
Oracle a while back, and the capability for that exists there.
 For example, If I wanted to replicate the XMLFOREST functionality within 
Firebird, I was, and still am, hoping that these external engines or something 
could help.
 

 Kind Regards,
 

 Robert.

[firebird-support] Charset of external table filename?

[Kjell Rilbe kjell.ri...@datadia.se [firebird-support]]

Hi,

I'm trying to create an external table to import a list of id numbers 
like this:

create table "ExLöpnr" external file 'D:\Löpnr.txt' (
   "Löpnr" char(7) character set win1252,
   "CRLF" char(2) character set win1252
);

But when I try to select from it, Firebird creates a new empty file 
named "LöPNR.TXT". This is what "LÖPNR.TXT" looks like if it's UTF8 
encoded but displayed as if it were WIN1252/ANSI/LATIN1 encoded.

Checking the system tables, the filename looks correct, but I assume the 
system tables encode that string in UTF8 (or UNICODE-FSS which would be 
identical in this case if I'm not mistaken).

It seems like Firebird does not transliterate this string correctly when 
passing it to the operating system's file operations.

This is in FB version 2.5.2.26540.

Known problem/bug? Or am I missing something? Fixed in later version of 
2.5 or in version 3? Any workaround except renaming the file to plain ascii?

Regards,
Kjell

-- 
--
Kjell Rilbe
DataDIA AB
E-post: kjell.ri...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

RE: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Timo,

<>.

Thanks - that tells me where to look and try and fix the problem.

Regards
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32

Re: [firebird-support] Firebird 3 PSQL Features

[Helen Borrie hele...@iinet.net.au [firebird-support]]

At 06:49 p.m. 24/09/2015, rgilland1...@gmail.com [firebird-support] wrote:


>Hi
>
>
>I am really interested in Firebird 3 new PSQL Features, other language support.
>
>
>Is there anywhere I could see a listing of them?

As usual for a Beta and a new release - in the release notes.  You can download 
the release notes at this page (link near the top):

http://www.firebirdsql.org/en/firebird-3-0-0-beta2/

>Any Idea when Firebird 3 is most likely to be released?

Release Candidate 1 is going through its final paces at the moment and, except 
for last things, the release notes are ready.  All going well, RC1 becomes the 
release version about a month later.

Helen

RE: [firebird-support] Support for OS X 10.11 El Capitan

[timo_romppa...@yahoo.com [firebird-support]]

I can confirm this is not a SIP issue. I disabled SIP altogether but the 
problem persists. I also tried the installer on another laptop with same 
results.

BR
Timo

RE: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

I suspect its not SIP, but the fact that we use an outdated package format. 
Looks like El Capitan has finally deprecated it.
I found this https://forums.developer.apple.com/thread/8676
Note the error message, they then switched from /var to /Applications and all 
was ok.
While we use /Library/Frameworks

Regards
Paul

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

[Glenn Thomas Hvidsten g...@vensafe.no [firebird-support]]

Forced writes are on.
I have not been able to recreate this kind of corruption locally so I don’t 
know what kind of errors are appearing. The message about corruption comes from 
a service technician in the field.
They usually do have a backup of the database, though, so it’s fortunately not 
a huge data loss.

Glenn Thomas Hvidsten

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 23. september 2015 22:24
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Securing database against corruption on systems 
that suddenly get turned off


On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten 
g...@vensafe.no [firebird-support] 
mailto:firebird-support@yahoogroups.com>> 
wrote:


We have FirebirdSQL (2.1) running on a client computer (Windows). This client 
has some problems with his power grid which causes the PC to suddenly and 
unexpectedly shut down in infrequent intervals (usually once or twice per day). 
Most of the time this doesn’t cause any problems, but once in a while this 
causes the database to be corrupted.
I’m not at all surprised that the database gets corrupted like this (as turning 
off a computer without shutting everything down gracefully can have that 
effect).


If you have turned off forced writes, corruption is likely.  If forced write is 
on, what are the errors you're seeing when the database is corrupted?  I'm not 
suggesting that you disregard advice about adding a UPS and make backups - 
excellent suggestions - but the Firebird architecture should survive a power 
failure if writes are being forced to disk in the correct order.  So I'm 
curious...

Good luck,

Ann



  Denne epost har blitt kontrollert for virus av Comendo Norge AS
This e-mail has been scanned for viruses by http://www.comendo.no



[Non-text portions of this message have been removed]