Hi,

I have a SQL script file that inserts data into the oracle 10g database. The script has correct data (in UTF-8 format). The client used is SQL *Plus in Windows machine. Some junk character is getting stored in the database.

Is the problem with SQL *Plus? Does it not support UTF-8 characters? In teh oracle forum, it is said that SQL * Plus supports UTF-8 characters in Unix systems by default.

If that is so, what other option do i have to execute the script in a windows box thru' SQL * Plus? BTW, it is mandatory for me to have the log files of the script execution. So, I ignored the iSQL Plus solution.

The characterset of the database is AL32UTF8. The codepage is 1252. NLS_LANG of client and the server is AMERICAN_AMERICA.WE8MSWIN1252.

Also if anybody could shed some light on the support of UTF-8 characters in SQL Loader, it will be of great help.

Any help will be appreciated.

Thanks,
Srividya R