[Zope] How can you insert strings with newlines into SQL database?

I have an SQL method: insert into mytable (col) values (<dtml-sqlvar text type="string">) the problem is that if 'text' contains a newline character gadfly won't accept this, since this apparently violates SQL syntax. So I can't insert strings that have newlines. What should I do? -- Itamar S.T. itamars@ibm.net