Hi,
I often use Export database as Batch Scripts followed by Excute Batch Scripts as a way of transferring the DB or alternatively backing it up.
The Export runs fine, but when I come to execute the Batch File on a particular Database I find the fields are bounded by single quotes (as is normal), but that the text within also contains un-escaped quotes of the sort
it's, O'Reilly and Joe's Diner. These single quotes “break” the execution. First of all I cannot understand why these single quotes aren't a problem in the actual live database. Then should I be configuring YOG differently?