PHWinfo - Afficher un message - finding non-ascii characters within a string

18/10/2007, 16h55

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

18/10/2007, 16h55	#2
Baron Schwartz Messages: n/a Hébergeur:	Re: finding non-ascii characters within a string 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