I want to embed a non-printable character into a varchar column in my table.

MSQL SQL has the CHAR function which generates the character based on the
ASCII value.

How can I do this in ElevateDB?
(Note that this script is just a text file that I am executing from within
the database manager, not a program)

EXECUTE IMMEDIATE 'INSERT INTO TABLEA VALUES (''A'' + CHAR(13) + ''B'')';

Thanks

Richard

> I want to embed a non-printable character into a varchar column in my
> table.
>
> MSQL SQL has the CHAR function which generates the character based on
> the ASCII value.
>
> How can I do this in ElevateDB?
> (Note that this script is just a text file that I am executing from
> within the database manager, not a program)
>
> EXECUTE IMMEDIATE 'INSERT INTO TABLEA VALUES (''A'' + CHAR(13) +
> ''B'')';

Use the # prefix with the ASCII Value:

EXECUTE IMMEDIATE 'INSERT INTO TABLEA VALUES (''A'' + #13 + ''B'')';

Reference:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=2&
topic=32


--
David Cornelius
CorneliusConcepts.com