Berko Bubu wrote:
INSERT INTO PRICE (ID, "NAME", COST)
You should not use double quotes around column names. Try to use backtick
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
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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php