Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with the ' character with MYSQL

Status
Not open for further replies.

kenaida

Programmer
Joined
Jul 9, 2001
Messages
3
Location
GB
I am trying to store someones company name into a VARCHAR field in MYSQl. the problem comes about when you have a ' character in the name ie Ried's Stores

Does anyone know how to overcome this. I have been using text parsing to change any ' characters to a ] character. however this is not a great solution.

Thanks
 
Does this work:
Ried''s Stores
put an extra ' in the sting.

It works on SQL server and Access but I am not sure it works on mySQL.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top