Afficher un message
Vieux 18/10/2007, 16h47   #1
Olav Mørkrid
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut finding non-ascii characters within a string

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
  Réponse avec citation
 
Page generated in 0,04757 seconds with 9 queries