When a $where string includes multibyte characters such as Chinese, sometimes you will notice that the $where clause is not interpreted correctly.
This problem can traced back to the operation$where = trim(preg_replace("/\s+/", " ", $where)); // replace tabs and newlines with ' '
Turns out that the /s criteria of the regex applies also to individual bytes of multibyte characters and when such a single byte meets /s criteria it would then be replaced with a "space byte", changing the multibyte character into something else. I solved this problem by adding the /u modifier to the regex: $where = trim(preg_replace("/\s+/u", " ", $where)); // replace tabs and newlines with ' '
For reference: http://www.regular-expressions.info/php.htmlQuote:If you want your regex to treat Far East characters as individual characters, you'll either need to use the mb_ereg functions, or the preg functions with the /u modifier.
Radicore Forum
Search
Help
Members
Register
Login
Home
