• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Junk values in Oracle 10g

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I was tempted to understand your post but since you don't UseRealWords, I chose to move on...
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic