[Koha-devel] Searching for garbage characters

[Cab Vinton]

> Try a last line such as
>
> WHERE NOT HEX(pname) REGEXP '^([0-7][0-9A-F])*$'
> or
> WHERE pname REGEXP '[^ -~]'

Thank you, Paul. Getting much closer now. It does retrieve a number of
valid accented characters, but since the number of affected records is
probably in the low 100's, it won't be difficult to visually scan the
results.

There might still be some records missed, so will do some testing &
see where we stand.

Many thanks again!

Cab Vinton
Sanbornton PL