escaping '-characters with Solid

["Angelic Engel" <angelic@medusa.nl>]

hi

I am using Minivend 3.12 on FreeBSD with Solid.
When I want to add or change a string in the database, I have problems with 
using single quotes (').
I thought that using the 'ESCAPE' tag with the string would solve this 
problem. But that is not the case.

Using ESCAPE in minivend puts a backslash before the quote (\'). 
Solid is an SQL database and according to the SQL standard that I have 
read and according to Solid a quote has to be escaped by adding an extra 
quote. 
I have tried this and it works OK (not using the escape and adding extra 
quotes myselve with a piece of perl code).

My question here is, should the escape not add a quote instead of the 
backslash. If not, when is this backslash used and is there also a standard 
minivend way to escape the quote with an extra quote


-------------------------------------------
Medusa, Media Usage Advice B.V.
Horsten 1, 5612 AX Eindhoven
tel: 040-2457024  fax: 040-2910774
URL: http://www.medusa.nl

Uw bedrijf voor Internet en Intranet zaken
-------------------------------------------