SEO

#1 (**permalink**) 02-28-2008, 07:01 AM

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;

thanks

#2 (**permalink**) 02-28-2008, 07:01 AM

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/...functions.html

Baron

#3 (**permalink**) 02-28-2008, 07:01 AM

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 <TABLE> WHERE <COLUMN> RLIKE '[^-, a-zA-Z0-9]'

[1]: http://dev.mysql.com/doc/refman/5.1/en/regexp.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

finding non-ascii characters within a string