On 3/15/06 11:42 PM, "mike" <mike@xxxxxxxxxxxxxxxx> 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
