--- On Mon, 10/6/08, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > I'm wondering if the OP has some line breaks in his > data that are > getting misinterpreted, or maybe his encoding on the two > dbs is > different and he's not taking care of that. Ahhh.... *looks at encoding* Well..they are both the same...BUT...they are set to ENCODING = 'SQL_ASCII'; That explains a lot....they should probably be set to Unicode UTF8.... Duh!!!! Any way to change encoding without dumping/restoring database?