Re: MDB2
| From: | Lukas Smith | Date: | Tue, 06 Dec 2005 10:25:32 +0000 |
| Subject: | Re: MDB2 | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40612@lists.php.net to get a copy of this message | ||
Daniel Convissor wrote:
Hey Guys (and there must be _some_ gals out there...): On Sat, Dec 03, 2005 at 09:56:35AM +0100, Lukas Kahwe Smith wrote:Which is effectively like having the delimiters stuck to the name of the column. Gna .. this means that the approach that we have decided on in MDB2 to just use delimiters for all schema manipulation queries is foo bar when it comes to Oracle, so we probably have to introduce a switch after all :-/ regards, Lukas(though there is still something fishy with oci8 as it needs quoteIdentifiers() applied .. maybe oci8 doesnt like identifier quoting unless you then always use then for everything?)I'm guessing the test created the columns/tables using delimited identifiers Delimited identifiers makes things case sensitive. So if the column was created with delimiters, such as '"somename"' will only respond to that exaxct name/case in between delimiters for the rest of time. So 'somename' without delimiting won't cut it.