Change: Also, to find out if a column contains non-ASCII characters, use LENGTH(col) <> LENGTHB(col)To set the connection charset...I finally managed to get the right environment variable to use to do the load:dos> set NLS_LANG=AMERICAN_AMERICA.UTF8dos> sqlplus ….Tell sqlplus to exit on error:WHENEVER SQLERROR   View changes from previous version. (Word count: 93)

Change: dealing with I18N data:Then you can try RAWTOHEX(iname) and DUMP(iname) which should show you how it’s encoded in the database.To set the connection charset...I finally managed to get the right environment variable to use to do the load:dos> set NLS_LANG=AMERICAN_AMERICA.UTF8dos> sqlplus ….   View changes from previous version. (Word count: 61)