RE: [PHP-DEV] Re: [PHP] PDO prepared statements and LIKE escaping

2008-08-06 Thread Texin, Tex
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: L

Re: [PHP-DEV] Re: [PHP] PDO prepared statements and LIKE escaping

2008-08-05 Thread Lukas Kahwe Smith
On 05.08.2008, at 09:34, Lester Caine wrote: 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 at