John English wrote:
On 17/03/2011 12:35, Bruce Wen wrote:
No. I have a file containing SQL/DDL to create a bunch of tables for my
app and initialise them, which I run using IJ. I want to be able to say
something like:
INSERT INTO foo VALUES('This','That','Foo\bBar');
but I can't. I've found a workaround. I basically wrote my own IJ which
includes an external function "ch()" so now I can say this:
INSERT INTO foo VALUES('This','That','Foo' || ch(8) || 'Bar');
I'm still amazed there isn't a built-in function for this.
The proper SQL syntax would be
INSERT INTO foo VALUES('This','That',U&'Foo\0008Bar');
See https://issues.apache.org/jira/browse/DERBY-1360
(No votes so far.....)
