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

Thanks,
C

Recommended Answers

All 2 Replies

What exactly you are trying to do ?

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/

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.