Re: Method to detect certain characters in column?

That's entirely possible.. which is the reason for cleanup.. we're
moving to a model where members can be queried by name, and UTF-8
isn't allowed in URLs, so we need to rename/remove users with those
types of names. A lot of these members are from years ago where we
were on mysql with not enough experience to sanity check everything,
or do things as we're doing now.

And yeah, that's how the names are. People got crafty.

*shrugs*

thanks again for all the help everyone!

On Mon, Jun 23, 2008 at 11:54 PM, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:
> 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
>
>