Re: [PHP-DB] Firebird return wrong value
[email protected] (Lester Caine)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Berko Bubu wrote: >>> INSERT INTO PRICE (ID, "NAME", COST) >>> >> >> You should not use double quotes around column names. Try to use backtick >> operator instead: >> INSERT INTO `PRICE` (`ID`, `NAME`, `COST`) >> Don't know if that solves the problem, but it's atleast good practice. >> Second, do you really need firebird database? >> It's pretty outdated database, and there are much better alternatives. > It's an existing system, so i can't change it. > I have tried with firebird 2.5 and same result. > > The value stored right. I have seen it in FlameRobin, ISQL, etc > And when i use native native lib (ibase_connect,ibase_prepare,ibase_execute) i get right value. > Maybe is it a bug in pdo_firebird driver ? This is possible ... Have you tried the other options to PDO::FETCH_ASSOC ? I've not bothered with the PDO drivers as the Firebird one can't cope with two-phase commits cross database, and I know that others have found the restrictions imposed by PDO prevent things working well in older style Firebird Applications. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk