Re: DB_DataObject and backticks
| From: | Justin Patrin | Date: | Wed, 08 Dec 2004 08:16:25 +0000 |
| Subject: | Re: DB_DataObject and backticks | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16101@lists.php.net to get a copy of this message | ||
On Tue, 7 Dec 2004 22:53:22 -0600, Joseph Szobody
<php-newsgroup@signaturetechstudio.com> wrote:
> Folks,
>
> I have a table named 'group' which is of course a reserved keyword. I was
> really hoping that DB_DataObject would use backticks so that it wouldn't be
> a problem, but evidently this is not the case.
>
> Any reason why not?
>
First of all, because not all DBMS use backticks. Second because some
mysql versions don't even support the backticks. That said, DB
supports these through quoteIdentifier() and DB_DataObject supports it
as well (I should know, I prepared the patches for both). Just put
quote_identifiers=1 in your DataObject.ini.
--
Justin Patrin