Junk values in Oracle 10g

[vikas malviya]

Hi all,

I m inserting the data into the table from the excel file,but when i checked the table some junk characters are displayed in the fields.

please let me know if anyone has faced the same issue.


Regards,
Vikas Malviya

[Paul Sturrock]

What do you mean by "junk characters"? What did you expect and what actually happened?

[vikas malviya]

Paul Sturrock wrote:What do you mean by "junk characters"? What did you expect and what actually happened?

Paul,
Thanks for reading the post,abt the Junk values, details are as follows

Technologies Used
Language:Java jdk1.5
DB:Oracle 10g

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.



Regards,
Vikas Malviya

[Tom Reilly]

I was tempted to understand your post but since you don't UseRealWords, I chose to move on...

[Martin Vajsar]

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.