Bug 172281

This issue is related to issue #161048 though instead of problems with DECIMAL it has to do with VARCHAR.

Suppose a VARCHAR column has content like the following stored:
<svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg>

I get the following back when using the 'Show SQL script for INSERT' function on one or more rows:

INSERT INTO TESTDB."test" ("id", "value") VALUES (1, svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg);

Instead of:

INSERT INTO TESTDB."test" ("id", "value") VALUES (1, '<svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg>');

Note the lack of surrounding quotes, the leading '<' and trailing '>'.

This results in an unusable (error generating) statement if you want to execute it because the string can not be 
converted to a suitable value.

I'm using Netbeans 6.7.1 in combination with Apache Derby. Let me know if you need any more information.