Member Avatar for bigfixcat

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

Thanks,
C

  • 3 Contributors
  • 2 Replies
  • 39 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by smantscheff

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

What exactly you are trying to do ?

Member Avatar for 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/

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.