Subject Transliterating - finding non ASCII characters
Author Chad Z. Hower aka Kudzu
I have a field that was marked as Unicode FSS that should have been ASCII. I
have a script which creates a new field, copies, drops old, and renames it.
This works fine on my debug DB, but somehow the live DB has some non ASCII
data in this field and when I try to apply this to the live DB is says
cannot tranlisterate.

Im not sure how this field got non ASCII data, prob some stupid user. But
the question is - there are 25,000 rows, how can I find out what row(s) have
this non ASCII data so I can look at them and maybe manually fix them up?

Chad Z. Hower aka Kudzu
"Programming is an art form that fights back"

Still doing your website by hand? Get a free content management system: