RE: finding non ascii characters in the database

Thanks again Michael. I don't fully understand all of this, but my big takeaway from your post is that something in our settings or environment may be handling the multi-byte characters that are coming from Informix, as multiple characters. That seems logical. I am not doing the ETL, but I think we're just using oracle's ODI product. I think it connects via jdbc and does an Oracle sqlloader process to get the rows into oracle. We're letting ODI do all of this because we want to capture changes during migrations etc.. ODI is putting triggers on all the tables selected for the migration of a certain app, stores any dml into it's own temp schema and process away based on our mappings and other things we tell it to do. It's a pretty cool product. Thanks, floyd ----- Original Message ----- From: "Ian Michael Gumby" >;im_gumby@hotmail.com