Re: Firebird return wrong value
| From: | Berko Bubu | Date: | Fri, 18 Jan 2013 13:58:32 +0000 |
| Subject: | Re: Firebird return wrong value | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48654@lists.php.net to get a copy of this message | ||
> > 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 ?