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 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