mySql - find non-Ascii character in html [duplicate]

Question

I'm trying to find all non-asci characters I have in my DB in a specific table and column. In that column are stored Html description, and in some of them I've exotic or non-existing characters (for example: Hà¶ganà¤s ).

I'm triyng to match them with this query:

SELECT * FROM project_version WHERE description REGEXP '[^()\x00-\xFF\,\.-\<\>="\' /:;&=]'

But I think I'm missing something, cause it returns all of my records. Does anyone any advice?

Thanks in advance

There's a similar question here that has multiple answers; this answer may be the best - it was added much later so it doesn't have as many upvotes, but it looks solid. — Ed Gibbs
– Ed Gibbs, Commented Oct 1, 2013 at 14:34
ASCII is actually only 0x00-0x7F, so [^\x00-\x7F] or [\x80-\xFF] will do it. — Gumbo
– Gumbo, Commented Oct 1, 2013 at 14:34

anubhava · Accepted Answer · 2013-10-01 14:38:05Z

0

Try moving hyphen to start or end otherwise it needs to be escaped also ^ will be treated as literal ^ in character class:

SELECT * FROM project_version WHERE description REGEXP '[()\x00-\x7F,.<>="\' /:;&=-]'

edited Oct 1, 2013 at 14:38

answered Oct 1, 2013 at 14:32

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mySql - find non-Ascii character in html [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related