Re: [firebird-support] Is windows better than Linux for Firebird 2.5 64 bit?

2012-11-05 Thread Lester Caine
trskopo wrote: > I am considering moving from windows to linux, but not sure if it is a good > idea. > > Any one can give me a hints about this matter? Most of my previously windows only customer sites have now allowed us to switch the servers to linux. These are using currently Apache/PHP/Fire

Re: [firebird-support] Is windows better than Linux for Firebird 2.5 64 bit?

2012-11-05 Thread Alexey Kovyazin
Hello, In essence, if you don't know answers for the questions you asked, you should not move to Linux. There are more pitfalls, which cannot be explained by short hints. Regards, Alexey Kovyazin IBSurgeon > Hi all, > > I am considering moving from windows to linux, but not sure if it is a go

[firebird-support] Is windows better than Linux for Firebird 2.5 64 bit?

2012-11-05 Thread trskopo
Hi all, I am considering moving from windows to linux, but not sure if it is a good idea. Any one can give me a hints about this matter? Is it Linux better than windows on the same hardware, regarding performance/security/etc? And if it's better, what distro should I choose and what file sy

[firebird-support] Re: FB 2.5.1: Embedded Server (Windows) on 32-bit systems

2012-11-05 Thread Dmitry Yemanov
05.11.2012 23:03, Thomas Steinmaurer wrote: > > At 07:50 AM 6/11/2012, Thomas Steinmaurer wrote: > > > >> The good thing with Embedded and SuperClassic is, that it can take > >> advantage of multiple CPUs/Core. > > > > Only if attaching to multiple databases, though. > > SuperClassic is mean

[firebird-support] Re: accessing 32 / 64 bit databases from any bitness (32/64) firebird server?

2012-11-05 Thread Dmitry Yemanov
06.11.2012 1:15, ehaerim wrote: > There is an application which has both 32/64 bit versions. > Each version has its own databases created. > The installed firebird is 64 bit version. > To access 32 bit databases, I ran fbserver.exe -a from DOS prompt with > Admin privilege. > When running isql to

[firebird-support] accessing 32 / 64 bit databases from any bitness (32/64) firebird server?

2012-11-05 Thread ehaerim
There is an application which has both 32/64 bit versions. Each version has its own databases created. The installed firebird is 64 bit version. To access 32 bit databases, I ran fbserver.exe -a from DOS prompt with Admin privilege. When running isql to access 32 bit databases, I got an error: St

Re: [firebird-support] What makes a column read only?

2012-11-05 Thread Werner F. Bruhin
Hi Thomas, On 05/11/2012 19:51, Thomas Steinmaurer wrote: > > > You can't set a new column value in an AFTER trigger. Use a BEFORE > trigger. > Thanks a lot, that did the trick. Werner [Non-text portions of this message have been removed]

Re: [firebird-support] FB 2.5.1: Embedded Server (Windows) on 32-bit systems

2012-11-05 Thread Thomas Steinmaurer
> At 07:50 AM 6/11/2012, Thomas Steinmaurer wrote: > >> The good thing with Embedded and SuperClassic is, that it can take >> advantage of multiple CPUs/Core. > > Only if attaching to multiple databases, though. SuperClassic is meant to take advantage of SMP with multiple attachments, even to a s

Re: [firebird-support] FB 2.5.1: Embedded Server (Windows) on 32-bit systems

2012-11-05 Thread Helen Borrie
At 07:50 AM 6/11/2012, Thomas Steinmaurer wrote: >The good thing with Embedded and SuperClassic is, that it can take >advantage of multiple CPUs/Core. Only if attaching to multiple databases, though. ./heLen

Re: [firebird-support] What makes a column read only?

2012-11-05 Thread Thomas Steinmaurer
> I have this table definition: > CREATE TABLE CONSUMPTION > ( > ID KEYS NOT NULL, > QUANTITY Integer DEFAULT 0, > UNITPRICE Numeric(18,2) DEFAULT 0, > CONSUMEDVALUE Numeric(18,2) DEFAULT 0, > REMARKS Varchar(50) COLLATE UNICODE_CI_AI, > CONSUMED Timestamp, > MATURITYFIR

Re: [firebird-support] FB 2.5.1: Embedded Server (Windows) on 32-bit systems

2012-11-05 Thread Thomas Steinmaurer
> in "Firebird-2.5-QuickStart.pdf" I've found this: > > [...]Windows Embedded now contains a SuperClassic instead of a SuperServer > engine. File locks are shared, so a database can be accessed by one or more > Embedded servers and a regular Classic or SuperClassic server at the same > time.[...

[firebird-support] What makes a column read only?

2012-11-05 Thread Werner F. Bruhin
Hi, I have this table definition: CREATE TABLE CONSUMPTION ( ID KEYS NOT NULL, QUANTITY Integer DEFAULT 0, UNITPRICE Numeric(18,2) DEFAULT 0, CONSUMEDVALUE Numeric(18,2) DEFAULT 0, REMARKS Varchar(50) COLLATE UNICODE_CI_AI, CONSUMED Timestamp, MATURITYFIRST Integer, MATURIT

[firebird-support] FB 2.5.1: Embedded Server (Windows) on 32-bit systems

2012-11-05 Thread patrick_marten
Hello, in "Firebird-2.5-QuickStart.pdf" I've found this: [...]Windows Embedded now contains a SuperClassic instead of a SuperServer engine. File locks are shared, so a database can be accessed by one or more Embedded servers and a regular Classic or SuperClassic server at the same time.[...]

[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
Hello Martijn, > >> > Regarding 3.1.4 and 3.2.4: I've found this example on how to change the > >> > blob type: > >> > UPDATE RDB$FIELDS SET RDB$FIELD_SUB_TYPE = 0 > >> > WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS > >> > WHERE RDB$FIELD_NAME='SOME_TEXT_BLOB_FIELD' AND

Re: [firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread Martijn Tonies
Hello Patrick, >> > 3.3 Doing everything manually >> > Means probably the most work, but appears to be the safest way at the >> > moment. >> > 3.3.1 I could start with the final UTF8 database, i.e. with all the >> > structure changes etc. included >> > 3.3.2 The source database would be accessed b

[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote: > > Hi, > Hi Martijn, thanks for your reply. > > 3.3 Doing everything manually > > Means probably the most work, but appears to be the safest way at the > > moment. > > 3.3.1 I could start with the final UTF8 database, i.e. with

[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
--- In firebird-support@yahoogroups.com, "Pierre Y." wrote: > > Not sure but FBClone (via > http://code.google.com/p/fbclone/wiki/ConvertBadEncodedFirebirdDatabases) > could help. > > I embedded its code into my application to provide automagic ISO8859_1 to > UTF8 conversion for my application (i