Postgres Pro
Downloads
Home   >   mailing lists

Re: Method to detect certain characters in column? - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Method to detect certain characters in column?
Date
Msg-id 48606FDC.60406@wildenhain.de
Whole thread Raw
In response to Re: Method to detect certain characters in column?  ("Ian Meyer" <ianmmeyer@gmail.com>)
Responses Re: Method to detect certain characters in column?  ("Ian Meyer" <ianmmeyer@gmail.com>)
List pgsql-general
Tree view 
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
> ----------------------
>  Señorita Lolita
>  Long Pig
>  täkäurgh
>  blåbärsöl
>  fuchér MkII
>  fuchér ver2.0
>  Gûm-ishi Ashi Gurum
>  kängnäve
>  Fuchér-version 2.1
>  fuchÃ(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
Attachment

pgsql-general by date:

Previous
From: "Michael Shulman"
Date:
Subject: what are rules for?
Next
From: "Ian Meyer"
Date:
Subject: Re: Method to detect certain characters in column?