• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Adding Special Characters To MySQL DB Using Java

 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
Thanks for responding....I am using the standard HTML textbox and textarea in my JSP.
Cheers
Mark
 
Cory Wilkerson
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic