Non standard chars

[KarveR]

Hi All, I have the very rare occurence of non-standard characters being loaded into one of my tables :

e.g 8PAõõõõMUST BE PICK

Is there any way of easily finding the records containing these non-standard characters (they vary , not always the same char).

LIKE '%õ%' is not really an option...
+----------+
| count(*) |
+----------+
| 2738167 |
+----------+
1 row in set (0.02 sec)

any other clues ideas etc gratefully welcomed.

cheers

Karv

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ingresman]

Quick and dirty solution would be to run down the table e.g select * from vvvv; and check that each character is printable (if you were using C) or a regular expression (way out of my depth here !) to chack that each character is valid. You may think of a better one e.g. chat(x) > 26.

regards

 

[KarveR]

Table is a little large really: 2,700,000+ records each with a whole heap of data (50 odd fields) total size nearing 5 gig.

thanks for the input tho

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ingresman]

Its just going to take a little while to run 5gb is not that large really, see it as a challenge.

I think in general though you should improve you input validation though