Larry Garfield wrote:
I'm building a multi-database system, although my main targets are MySQL,
Postgres, and SQLite.
How would those handle something like "a string that ends in 100%"?
Personally this is one of the reasons that PDO has never attracted me.
Providing the tools to flatten some of the differences between *SQL*
variations is just as important as flattening the name differences in functions.
My own use of LIKE tends to process the string and then add the wrapping %%
when passing it to the param array, but do all databases HANDLE 'escaped %' in
the LIKE data? Firebird allows a escape character but you need to include it
in the SQL
LIKE '%100#%%' ESCAPE '#'
But I think MySQL actually uses \% to achieve the same thing -
and the ESCAPE '\' is then optional?
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
