Re: Firebird return wrong value

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