On May 23, 2004, at 2:55 PM, Ard Biesheuvel wrote:
George Schlossnagle wrote:I don't get this question, can someone reiterate the full context of it for me?
For instance, if you prepare the statement
"SELECT * FROM <table> WHERE id=?"
Firebird can figure out the type of the 'id' param, meaning you don't have to bind it to a certain type, whereas the emulated param binding routines cannot.
Additionally, MySQL is a lot more forgiving than Firebird if you put quotes around non-string arguments inside an SQL statement. So we might decide to make the type specification optional, and let it default to 'string'.
If firebird can figure that out, that's great. It should store the column type info internally and use it when bind is called. Mysql doesn't provide this facility, so it has to be more aggressive in it's quoting. These largely seem like driver-internal issues - at least I don't see at all how this should affect the public-facing api.
George
-- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
