2 messages in com.mysql.lists.javaRe: Inserting braces into the db
FromSent OnAttachments
David Wall12 Apr 2000 21:38 
Mark Matthews13 Apr 2000 03:45 
Subject:Re: Inserting braces into the db
From:Mark Matthews (mmat@worldserver.com)
Date:04/13/2000 03:45:10 AM
List:com.mysql.lists.java

The escape processor in MM.MySQL 1.2 is admittedly broken. If you're not using escape codes, just turn it off (Statement.setEscapeProcessing(false)). 2.0pre is much better, and only processes escape codes outside of '', and also allows you to use a \ to escape a brace.

-Mark (author of MM.MySQL)

On Wed, 12 Apr 2000, David Wall wrote:

I'm not sure what the EscapeProcessor class does in MM, but it seems to monkey
around with braces {} being inserted into the database.

On input, I have: <script language=JavaScript>function testFunc(){return
true;}</script>

In the database (on retrieve), I end up with: <script
language=JavaScript>function testFunc()return true;{}</script>

I can see that braces are significant with the escape processor, but I'm not
sure how to unescape this. Is there a \{ or the like to tell the escape
processor that this brace is special?