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
Jump to PostWhat exactly you are trying to do ?
All 2 Replies
debasisdas
580
Posting Genius
Featured Poster
What exactly you are trying to do ?
smantscheff
265
Veteran Poster
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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.