File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes scientific symbols insertiong in database. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "scientific symbols insertiong in database." Watch "scientific symbols insertiong in database." New topic

scientific symbols insertiong in database.

Ramasubramaniam Rathinasubbu
Ranch Hand

Joined: Jun 09, 2010
Posts: 44
Dear friends,

when i insert the scientific symbols into the database like Ellipses(Alt+0133) and bullet (Alt+0149), Endash (Alt+0150), Emdash(Alt+0151) , in View retriving using xml, i am getting ??? instead of the scientific symbols

thank you,
R. Ramasubramaniam.
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13025
Perhaps the software you are using to view the XML simply can't display those symbols.

If this was my problem I would use an editor capable of showing the HEX values of characters to see what values are really there.

Wendy Gibbons

Joined: Oct 21, 2008
Posts: 1107

it is also possible you are using a datatype on your database that can't handle these symbols.

but I would try Bill's suggestion first, this is a follow up answer.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19851

It's also possible that your database is configured to use a charset which can't represent those characters.
I agree. Here's the link:
subject: scientific symbols insertiong in database.
It's not a secret anymore!