Escape characters in type CHAR fields - problem?

[Jez Tucker]

Hi,

I'm not sure if this is the right list to post to (it's my first mysql list
post) so please bear with me if I'm in the wrong place.

I've been reading the manuals regarding the inclusion of escape characters
in CHAR fields.

E.G. INSERT INTO <table> VALUES('hello\\nhow are you?');

Am I right in thinking that one cannot, at present, insert an escape
character (notice not escaped character) into the field?

Escape char

Code    Base
\\033   Oct
27      Dec
1B      Hex


I.E. INSERT INTO <table> VALUES('hello <ESC CODE> \\nhow are you?`);

I noted in the documentation that you could also insert CTRL-Z codes, though
I saw no escape character for this.  How would one do this?

Regards,

Jez T.
---
Jez Tucker
Cool Beans Productions Ltd (UK)
Tel: [phone]
Fax:[phone]
www.coolbeans.co.uk
www.coolbeansworld.com