Paul Sturrock wrote:What do you mean by "junk characters"? What did you expect and what actually happened?
Thanks for reading the post,abt the Junk values, details are as follows
1.Data is been inserted from the Front End(Java)
2.an interface is provided to the user to upload the excel file,whose data is been read from the java aplication and then stores the data to the database.
3.nw when we see the data in the database,then junk values are there with the existing data..not only that when we fire a query to find the data in the db for that particular column..then SQL Developer tool gets Hangs Up.
4.The Junk values which we figured out from the table is like (?,and the oppsite sign of ? and reverse of ?)
guys if you hv faced ny similar issues and hv come up with the solution,please let me knw....as its a retail sector......uploading done quite on regular bases to upload the products.
If it is your application that parses the Excel file and stores its data into database, I'd suggest to inspect what is being retrieved from the Excel file. That way you'll see whether the problem lies in extraction of the data from the Excel file, or in their insertion into database.
Does the file contain national characters? In that case check the database and session character sets.
What other tools except SQL Developer did you use to display the data? Maybe your tool cannot display the national characters.