On 3/15/06 11:42 PM, "mike" <mike(at)thegodshalls(dot)com> wrote:
> If you don't care to store those characters then maybe you should change
> the database character set to use SQL_ASCII instead of UTF-8. I believe
> ASCII will quietly discard those characters when converting from UTF-8.
I thought about that, but I do want to allow UTF-8 to be stored. I just
want it to replace illegal characters with some valid character so that
invalid records will load. Even if I preprocess the data, I can do no more
than that.
Wes