This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
Similar Threads
JConnect and Turkish
Editing Special Character
handling unicode characters in jsp
Special characters
textfield and utf-8 format