Subject | Re: DML - Inserting ASCII characters into a string? |
---|---|
Author | Adam |
Post date | 2007-02-17T23:27:33Z |
> Is there a DML function or other means available to insert ASCII codesThere is no 'DML function', but by the same token, I don't see the
> into a VARCHAR?
>
> I have a stored procedure that returns a VARCHAR, and I would like to
> insert non-typeable ASCII characters, such as tab or carrige return
> (ASCII code 13) into the return value.
problem with tab or crlf?
-- Return tab
SomeValue = ' ';
-- Return CRLF
SomeValue = '
';
If you wanted an ascii number->char function however, you should take
a look at ib_udf.sql in your udf folder
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
Adam