Re: finding non-ascii characters within a string

2007-10-18 Thread Ralf Hüsing
Olav Mørkrid schrieb: > 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? Maybe via a inverted regular expression [1] like this?: SELECT * FROM WHERE RLIKE '[^-, a-zA-Z0-9]' [1]: http://dev.mysql.c

Re: finding non-ascii characters within a string

2007-10-18 Thread Baron Schwartz
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

finding non-ascii characters within a string

2007-10-18 Thread Olav Mørkrid
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