RE: [firebird-support] Re: FB 3.0 Replacing ICU libraries

2017-09-28 Thread Magnus Johansson mag...@nimajo.se [firebird-support]
Hi Dany, Do you mind sharing which character set you use and how your collation is defined? Mvh Magnus Johansson

[firebird-support] Re: FB 3.0 Replacing ICU libraries

2017-09-22 Thread danymar...@gmail.com [firebird-support]
I am using FB3.0.2 with swedish collation, but with the unicode libs that worked with FB2.5. I have not had the time to research the use of newer versions of these libraries. This is what i do: Put the icudt44.dll, icuin44.dll and icuuc44.dll lib files in Firebird_3_0 (might have typos here,

[firebird-support] Re: FB 3.0 Replacing ICU libraries

2017-09-12 Thread Magnus Johansson mag...@nimajo.se [firebird-support]
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, September 12, 2017 10:32 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: FB 3.0 Replacing ICU libraries > I would appreciate if anyone could just answer if this is the corr

[firebird-support] Re: FB 3.0 Replacing ICU libraries

2017-09-12 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > I need unicode collation for Swedish and therefore I have to replace the ICU > libraries. > > First I have downloaded the snapshot for FB 3.0.3 for Windows > (Firebird-3.0.3.32802-0_x64). > Then I went to

Re: [firebird-support] Re: FB 3.0, a few questions on a new future

2016-06-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.06.2016 7:23, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: >> 1) Since FB 3.0 support WireCompression, should I still use Zebedee? > > No point anymore. ZeeBeeDee can restrict access by key, not only do encryption and compression of channel. -- WBR, SD.

[firebird-support] Re: FB 3.0, a few questions on a new future

2016-06-02 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
03.06.2016 05:24, trsk...@yahoo.com wrote: > > 1) Since FB 3.0 support WireCompression, should I still use Zebedee? No point anymore. > 2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ? > Usually I used this statement : > > UPDATE RDB$TRIGGERS a set a.RDB$TRIGGER_SOURCE =

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

2016-06-02 Thread trsk...@yahoo.com [firebird-support]
Dear Mark, Thanks for you info, solved the problem. Regards, Anto.

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

2016-06-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-06-02 6:20, trsk...@yahoo.com [firebird-support] wrote: >> What value must it have? Add a default clause to this statement. Or > add > > the field as nullable, populate with data and then alter to NOT > NULL. > > I have tried to add field as nullable, then tried to alter to not > null. >

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

2016-06-02 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
>> What value must it have? Add a default clause to this statement. Or add > > the field as nullable, populate with data and then alter to NOT NULL. > > I have tried to add field as nullable, then tried to alter to not null. > > UPDATE TMP_RPT SET ID1 = '5'; Commit; > (This statement is OK) >

[firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

2016-06-01 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
02.06.2016 07:42, trsk...@yahoo.com wrote: > > I have a table with existing data & got a problem to add field that must > have a value -> alter table Tbl1 add Fld1 int not null. What value must it have? Add a default clause to this statement. Or add the field as nullable, populate with data and

[firebird-support] Re: FB 3.0

2016-04-29 Thread david.edi...@yahoo.com [firebird-support]
Hi, Thanks everyone for your ideas on this - will try the data pump idea into a new FB 3 database... Cheers, Dave

R: [firebird-support] Re: FB 3.0 and PHP connection

2016-04-26 Thread 'palbe...@libero.it' palbe...@libero.it [firebird-support]
Hi, also with this format I've got the same result (=NULL) :-( Best Regards Messaggio originale Da: r...@graficalc.nl [firebird-support] <firebird-support@yahoogroups.com> Data: 26/04/2016 17.03 A: <firebird-support@yahoogroups.com> Ogg: [firebird-support] Re: FB

[firebird-support] Re: FB 3.0 and PHP connection

2016-04-26 Thread r...@graficalc.nl [firebird-support]
You could try separating the hostname from the database location (passing the hostname with host=). I have this: $conn = new PDO("firebird:host=$databasehost;dbname=$databasename;charset=utf8", $databaseuser, $databasepass);

Re: [firebird-support] Re: FB 3.0

2016-04-25 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: FB 3.0

2016-04-25 Thread Ricardo Uzcategui ricardou...@cantv.net [firebird-support]
try using backup transportable (-T) and then, restore with fix_fss_m -fix_fss_d options, same as you was do. On Mon, Apr 25, 2016 at 5:32 AM, david.edi...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hi, > > Can anyone help? I'm trying to upgrade to FB 3 from

Re: [firebird-support] Re: FB 3.0

2016-04-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.04.2016 12:02, david.edi...@yahoo.com [firebird-support] wrote: > How to I migrate our FB2 database to using FB3?? Create a new database on FB3 from scratch and pump data from old one. -- WBR, SD.

[firebird-support] Re: FB 3.0

2016-04-25 Thread david.edi...@yahoo.com [firebird-support]
Hi, Can anyone help? I'm trying to upgrade to FB 3 from 2.5.2 (classic) on a Centos 6.3 virtual machine. Attempting to use gbak (FB 3) to restore the .gdb file (FB 2.5.2) but getting the following error: gbak: ERROR:Malformed string gbak: ERROR:Invalid data detected. Use

Re: [firebird-support] Re: FB 3.0 Multiuser Environment

2014-12-23 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you Dmitry. I will try better tests. Hugo Eyng Em 22/12/2014 16:53, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] escreveu: 22.12.2014 21:18, Hugo Eyng wrote: I added the settings SharedDatabase = true and SharedCache = false like you told and everything worked fine.

Re: [firebird-support] Re: FB 3.0 Multiuser Environment

2014-12-22 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello Dmitry Thank you for your answer. I added the settings SharedDatabase = true and SharedCache = false like you told and everything worked fine. Shouldn´t those settings be present in firebird.conf? I had to add them manually. About your question 'why not superserver', I performed two

[firebird-support] Re: FB 3.0 Multiuser Environment

2014-12-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.12.2014 21:18, Hugo Eyng wrote: I added the settings SharedDatabase = true and SharedCache = false like you told and everything worked fine. Shouldn´t those settings be present in firebird.conf? I had to add them manually. They do exist in v3 firebird.conf, be it official Beta or