Subject Re: [firebird-support] ATTN Helen; Re: varchar(2048) holds 1012
Author Helen Borrie
At 04:57 PM 1/01/2004 +0000, you wrote:
>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
>wrote:
> > etc.) that might be causing the exception? The ib_udf string
>functions
> > have a known bug that none of them will accept strings longer than
>80
> > bytes, making them useless for processing longer strings.
>
>Helen, wasn't that issue worked around by declaring CSTRING(32767)
>instead of CSTRING(80), as reported on sourceforge.firebird-devel,
>Sunday, 21 December 2003 7:33 PM by Jean Derrie Rigo? I tested it
>and it appeared to be valid.

Sure, it works around the problem, but it doesn't fix the bug. There is a
ton of UDFs out there that pass CSTRING(80) in the continued expectation
that the purpose of the parameter is to set a start address. It works
properly in IB 5.6 and is broken in all Firebirds. We continue to ship UDF
scripts that declare CSTRING(80).

/heLen