Method to detect certain characters in column?

Hi Ian,

Ian Meyer wrote:
Ah, so I forgot to mention the one caveat to this (sorry!) was there
was a ton of punctuation/spaces and other ilk so this is what I came
up with:

bco=# select name from member where not (name ~ '^[A-Za-z0-9[:punct:] ]*$');
name

S±orita Lolita
L Pig
¤¤urgh

MkII
ver2.0
G»m-ishi Ashi Gurum
¤¤ve
F 2.1
(c)r

Uh, is that really the name as it should be? To me it
looks much more like UTF-8 stored in SQL-Ascii. Maybe
converting it correctly would help?

Cheers
Tino