locate non ascii in a string

[bigfixcat]

Hi Everyone, this my first time. My question is how can I locate a non-ascii character in a string/field?

Thanks,
C

[debasisdas]

What exactly you are trying to do ?

[smantscheff]

You can search for text fields containing non-printing characters with a regular expression:

select mytextfield from mytable where mytextfield rlike "[[:cntrl:]]"

To search for non-ascii use the regexp "[^[:ascii:]]"
For other character classes see here: http://www.petefreitag.com/cheatsheets/regex/character-classes/