... It is not unusual to create triggers for the firstname and lastname fields to provide uc_fn and uc_ln which are then indexed also, so searching is a lot ...
This solution will not work. Both InterBase and Firebird allow case insensitive searches, as does MySQL. The php interface should allow that option to be...
This solution will not work. Both InterBase and Firebird allow case insensitive searches, as does MySQL. The php interface should allow that option to be...
It may not be a problem. Here is what the documentation says: Simultaneous connections Only Classic and SuperClassic allow simultaneous connections to a...
... This quote refers to *servers*, not clients. The Golden Rule with InterBase and with older versions of Firebird is/was that two **servers** could not be...
... Please don't top post ... I do not understand your problem? I made no mention of just capitalizing some letters. Shadow columns which are all upper case or...
Hi, ... Actually you can, and yes McGrath and van Duran would be found. When uppercasing both the variable you give to the search (From PHP) and the sql to...
... Indeed it would be absurd. That's not what I suggested, instead I suggested as one option to write a middle layer, between your applications and your...
Hi, We migrate from interbase 6 to Firebird about 2002. Now, we use Firebird 2.5 CS under Linux. We use about 20 differents database on one classic service. ...
... Thanks, Lester. I apologize for not understanding your first post on this. Reading the article you referenced explained your solution, which would surely...
Thanks for your response. I apologize for not understanding the solution you proposed. I read the article referenced by Lester and now understand the...
... The original author is no longer around, but did a great job with building the version of php_interbase shipped since PHP5.0. Marius has added a few small ...
... We are using PHP 5.2 with InterBase 6 at present but want to switch to Firebird. We have been told the interface from PHP is the same as that for...
... We are using PHP 5.2 with InterBase 6 at present but want to switch to Firebird. We have been told the interface from PHP is the same as that for...
... If you have a working Interbase link, then that will work exactly the same into a Firebird database! There is no difference, although if it's using the PHP...
... http://groups.yahoo.com/group/firebird-php/ for PHP 'traffic' ;) I've linked the reply to there. PDO does not make the full range of 'transactions'...
Hello, we have a web site with PHP5.3 and firebird 2.5 database. Some queries that search in heavy tables, about 1,8 million of records, with joins to other ...
Santiago Laparra wrote: Santiago initial posts are always moderated, so can take a little time to appear. I've killed the duplicate ;) ... The trick is not to...
Hello, ... Have a look on the execution plan and I/O stats. You can get both by using the Trace API, as you are on Firebird 2.5. ... Are you using some kind of...
... Try ibase_fetch_object ($rslt, IBASE_TEXT ) This will return the text of the blob in $rec->MNTNM rather then the blob ID While 5.3.x is after the problem...
Hi, I don't succeed that my transactions are readonly. I run the following script: $conn = ibase_pconnect('BSFBTEST:swimranking_raw', 'SYSDBA', 'masterkey',...
It seems that now the YiiFirebird extension https://github.com/robregonm/YiiFirebird is stable enough (please let me know it is not so) for merge in...
I am stalled in trying to get these three working together and would appreciate some help. I have installed XAMPP 1.8.1 and have followed the instructions...
I am trying to access a firebird database created by Fishbowl Inventory Systems. When I try to connect, I get the not defined message. I know what the...
... not nescessary if the serveur and the PC is on Windoss OS, but the best pactice is on use Gback and Restore methode for the DB. Are you sure, you are the...
... The user name and password are defined at *server* level. In a new server installation, they will be SYSDBA (user) with masterkey (password). If you are...
