File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Adding Special Characters To MySQL DB Using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Adding Special Characters To MySQL DB Using Java" Watch "Adding Special Characters To MySQL DB Using Java" New topic
Author

Adding Special Characters To MySQL DB Using Java

Mark Gowdy
Greenhorn

Joined: May 14, 2001
Posts: 28
Hi,
I am trying to add occasional special characters (eg, accents, umlauts) to the mysql db and return them successfully. When I try to display the results I get a totally different character.
The weird thing is that when I add it from a textarea and display it, everything is fine. When I add it in a textbox it does not work fine.
Any ideas would be most gratefully appreciated.
Thanks
Mark
Cory Wilkerson
Ranch Hand

Joined: Aug 14, 2001
Posts: 84
What sort of textbox are you talking about? HTML's standard text input or rather an awt component, a swing componenet, etc?
Mark Gowdy
Greenhorn

Joined: May 14, 2001
Posts: 28
Hi
Thanks for responding....I am using the standard HTML textbox and textarea in my JSP.
Cheers
Mark
Cory Wilkerson
Ranch Hand

Joined: Aug 14, 2001
Posts: 84
So, to clarify...
You're attempting to dump these special characters into a MySQL database via standard HTML controls, ie, text inputs and text areas. When you do so via a text area and then display your text all is well, however, when you do so via a text input...it doesn't work out.
Do I understand your issue before I attempt to duplicate this?
Cory
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Adding Special Characters To MySQL DB Using Java