OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Unprintable characters in regexp

From: Thomas Spahni (tsplawbiz.ch)
Date: Tue Apr 07 2009 - 09:14:37 CDT

Hi

How can I specify 'unprintable' characters is a MySQL regexp ?

Query is (example only):

SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';

I'm looking for an equivalent of the search part of a sed expression like
this:

s/Ã\xA0/à/g

which means I want to include a character with code hex A0 in the regexp.
According to the manual this sytax is not supported for regexp.

Any other way to do this?

Tom

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql