If you are supporting international users, then you also have to worry about 
the full-width versions of the operators (%, *, etc.)
Whether they are treated the same as half-width characters depends on the 
database. Oracle for example treats them as equivalent.


-----Original Message-----
From: Lester Caine [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 05, 2008 12:35 AM
To: PHP internals
Subject: [PHP-DEV] Re: [PHP] PDO prepared statements and LIKE escaping

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

Reply via email to