![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Thu, Jun 11 2009 6:48 PM | Permanent Link |
"Richard Speiss" | 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 |
Thu, Jun 11 2009 7:11 PM | Permanent Link |
"David Cornelius" | > 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 |
This web page was last updated on Thursday, July 10, 2025 at 10:18 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |