Escaping for a MySQL INSERT

Scripting Forums AppleScript Studio & Xcode
#1

I’m plowing through this project of converting a MSSQL database circa 2000 to a MySQL database and built a studio app to help me follow along and track errors and stuff…is there any all encompassing command that will escape all characters in a string like Javascripts escape(string) or PHP’s addslashes(string) or mysql_real_escape_string(string) functions? A shell script would be fine as I don’t think there is anything like that native to AppleScript.

#2

Hi,

AppleScript can do this with the help of perl

set a to "myText"
set b to do shell script "perl -e 'use URI::Escape; print uri_escape(\"" & a & "\")';"
#3

Perfect! Thanks!