Subject | Re: [ib-support] SQL questions |
---|---|
Author | Ian Newby |
Post date | 2001-06-28T09:12:33Z |
Hi,
There is a bug in the SQL definition of the ASCII_CHAR udf function. I
don't remember what the correct definition is, but you can work around
it by using the following:
EOL = SUBSTR(ASCII_CHAR(10),1,1) || SUBSTR(ASCII_CHAR(13),1,1);
I've been using this for months.
Regards,
Ian Newby
There is a bug in the SQL definition of the ASCII_CHAR udf function. I
don't remember what the correct definition is, but you can work around
it by using the following:
EOL = SUBSTR(ASCII_CHAR(10),1,1) || SUBSTR(ASCII_CHAR(13),1,1);
I've been using this for months.
Regards,
Ian Newby