aspose 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
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
 
Consider Paul's rocket mass heater.
 
subject: Adding Special Characters To MySQL DB Using Java