regex - filtering out chinese utf8 characters
| From: | Merlin Morgenstern | Date: | Thu, 30 Jul 2009 18:13:49 +0000 |
| Subject: | regex - filtering out chinese utf8 characters | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-296069@lists.php.net to get a copy of this message | ||
Hi there,
I am trying to filter out content that is not ascii. Can I do this with regex? For example:
$regex = '[AZ][09]';
if (preg_match($regex, $text)) {
return TRUE;
}
else {
return FALSE;
}
The reason I need to do this is that I am doing a mysql query with the text and I need to make sure it is not UTF8. Otherwise I do get following error:
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
I am new to regex and would be happy for a jump start to get this fixed.
Best regards, Merlin