Hi,
Olav Mørkrid wrote:
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
the column can be any string like "hello, world" or "norwegian
characters æøå here".
refer to these pseudo examples:
SELECT * FROM TABLE WHERE COLUMN CONTAINS CHARACTERS BETWEEN 128 and 255;
SELECT * FROM TABLE WHERE COLUMN CONTAINS CHARACTER = 240;
See the ASCII() and ORD() functions:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
