Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

inserting string values with an apostrophe

 
Eric Espares
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everybody,
I have a question: How can I insert or update an employee name into my database that the string values have an apostrophe? For example Marina O'Reili (note the apostrophe ') will not be accepted as employee name.
Any inputs?
Thanks,
Eric
 
brad balmer
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use a PreparedStatement instead of a regular Statement.
Therefore you would have:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic