https://community.hpe.com/t5/operating-system-linux/ascii-to-utf-8/m-p/3824596#M100409 hi suchitra,<BR /><BR />To load the data, use the control files's <BR />CHARACTERSET clause to specify the character set.<BR /><BR />Oracle8i/9i/10g Utilities Guide has more info on the clause.<BR /><BR />hope this helps!<BR />kind regards<BR />yogeeraj Mon, 17 Jul 2006 04:44:44 GMT Yogeeraj_1 2006-07-17T04:44:44Z https://community.hpe.com/t5/operating-system-linux/ascii-to-utf-8/m-p/3824595#M100408 Hi all,<BR />I am receving a test file which contains some chineese in ASCII and I need to convert it into UTF-8 format.<BR /><BR />We run a sql loader to load the data into the data base. After I load the data , I see a junk values or some funny characters instead of chinese charaters. <BR /> The file is droped in our unix m/c. <BR />Can you please help me to find a proper character set to be used in the control file le or how do I convert ASCII to UTF -8 while ftp ing the file.<BR /><BR />Its a critical issue. Eagerly waiting for u'r reply.<BR /><BR />Regards<BR />Suchitra Mon, 17 Jul 2006 04:19:30 GMT https://community.hpe.com/t5/operating-system-linux/ascii-to-utf-8/m-p/3824595#M100408 suchitra 2006-07-17T04:19:30Z https://community.hpe.com/t5/operating-system-linux/ascii-to-utf-8/m-p/3824596#M100409 hi suchitra,<BR /><BR />To load the data, use the control files's <BR />CHARACTERSET clause to specify the character set.<BR /><BR />Oracle8i/9i/10g Utilities Guide has more info on the clause.<BR /><BR />hope this helps!<BR />kind regards<BR />yogeeraj Mon, 17 Jul 2006 04:44:44 GMT https://community.hpe.com/t5/operating-system-linux/ascii-to-utf-8/m-p/3824596#M100409 Yogeeraj_1 2006-07-17T04:44:44Z