File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Junk values in Oracle 10g

 
vikas malviya
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "junk characters"? What did you expect and what actually happened?
 
vikas malviya
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 618
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was tempted to understand your post but since you don't UseRealWords, I chose to move on...
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic