Apostrophe in text variable causes SQL syntax error

[Terry Judd]

Useful information - thanks Mark.

Terry...

> Hi Terry,
> 
> Yes, this is normal. You need to escape the apostrophe. There should
> be a list of characters that need to be escaped in your MySQL
> documentation somewhere. You can write a script that converts the
> data before sending it to the server.
> 
> Best regards,
> 
> Mark Schonewille
>