Re: Inserting control characters in SQL

2011-03-11 Thread John English
On 11/03/2011 17:46, John English wrote: On 11/03/2011 17:42, Peter Ondruška wrote: Have you tried \b ? Hmm, silly me. I tried RTFMing -- stupid thing to do! OK, now I've tried it. It doesn't work. LENGTH('\b') == 2, not 1. Any other suggestions? ---

Re: Inserting control characters in SQL

2011-03-11 Thread John English
On 11/03/2011 17:42, Peter Ondruška wrote: Have you tried \b ? Hmm, silly me. I tried RTFMing -- stupid thing to do! John English | My old University of Brighton home page is still here: | http://www.it.bri

Re: Inserting control characters in SQL

2011-03-11 Thread Peter Ondruška
Have you tried \b ? Peter On Mar 11, 2011 4:41 PM, "John English" wrote: > I have a DDL schema which I am processing using IJ. I want to insert a > row into a table containg a backspace character: > > CREATE TABLE foo (name VARCHAR(20), value VARCHAR(200)); > INSERT INTO foo VALUES('first',); > >

Inserting control characters in SQL

2011-03-11 Thread John English
I have a DDL schema which I am processing using IJ. I want to insert a row into a table containg a backspace character: CREATE TABLE foo (name VARCHAR(20), value VARCHAR(200)); INSERT INTO foo VALUES('first',); where is an actual backspace character. I foolishly tried CHAR(8) but of course