> Hi christoph, this is bug, but this bug is Yours,
>
> let we see the definition of STRLEN function
>
> DECLARE EXTERNAL FUNCTION substrlen
> CSTRING(255), SMALLINT, SMALLINT
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_substrlen' MODULE_NAME 'ib_udf';
>
> So if You exceed 255 chars, the function fails, it's OK.
>
> You can write Your own strlen with longer strings.

Declaring it with CSTRING(somethinglonger) should work.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com