find rows with non-ascii values in a column

Question

How can I evaluate whether a column contains any non-ascii characters in mysql? In this case the charset is actually latin1, so I'm just looking for high-byte chars.

I tried this:

select * from company where ticker regexp concat('[', x'7f', '-', x'ff', ']')

but this returns this error:

ERROR 1139 (42000): Got error 'invalid character range' from regexp

Paul Dixon · Accepted Answer · 2009-01-20 16:39:13Z

9

There must be an easier way to do this, but all the typical escapes I thought would work, didn't. So here is one, ugly solution:

select * from company 
where ticker regexp(concat('[',char(128),'-',char(255),']'));

answered Jan 20, 2009 at 16:39

Paul Dixon

302k54 gold badges315 silver badges349 bronze badges

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

Collectives™ on Stack Overflow

find rows with non-ascii values in a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related