> 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 _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
