aspose file tools*
The moose likes JDBC and the fly likes Junk values in Oracle 10g Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Junk values in Oracle 10g" Watch "Junk values in Oracle 10g" New topic
Author

Junk values in Oracle 10g

vikas malviya
Greenhorn

Joined: Aug 06, 2009
Posts: 14
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
Bartender

Joined: Apr 14, 2004
Posts: 10336

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


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
vikas malviya
Greenhorn

Joined: Aug 06, 2009
Posts: 14
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
Rancher

Joined: Jun 01, 2010
Posts: 618
I was tempted to understand your post but since you don't UseRealWords, I chose to move on...
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Junk values in Oracle 10g