This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help. Special Characters(�) retrieval from the database using JDBC

 
Raghu Rao
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to retrieve Trademark(�) character from the database using java. The driver used is a Default DB2 JDBC Driver. When I retrieve registered (�) character, I am able to see it perfectly fine, but when I retrieve trademark (�) character, I get a question mark character (?). Please let me know what I would have to do to pick the trade mark character.

I am creating a connection, creating a statement, calling executeQuery with a stored proc., and then tried calling getString and getBytes, but wasn't successful.

Please let me know if you know how I should retrieve the Trademark(�) character.

Thanks,
Raghu

[ October 13, 2004: Message edited by: Raghu Rao ]

[ October 13, 2004: Message edited by: Raghu Rao ]
[ October 13, 2004: Message edited by: Raghu Rao ]
 
William A White
Ranch Hand
Posts: 35
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Raghu Rao:

I am creating a connection, creating a statement, calling executeQuery with a stored proc., and then tried calling getString and getBytes, but wasn't successful.

Please let me know if you know how I should retrieve the Trademark(�) character.


I had a very similar problem with French characters. It turned out that the particular installation of Tomcat/Linux/Java that I was using was not picking up the correct default character encoding - adding the CharSet parameter to the JDBC URL solved my issue - something like your_url_here?CharSet=ISO-8859-1
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic