Subject Re: [ib-support] Strange things happen to SP Parameter
Author Helen Borrie
At 01:13 PM 7/03/2003 +0100, you wrote:
>Hi all,
>I use the latest stable Firebird release with Delphi 5 Pro. and the FIBPlus
>Components. In my Database there are several Stored Procedures. Some of them
>have about 20 Parameter of different types like INTEGER or VARCHAR. Most of
>the VARCHAR-Parameter have a length of about 100 to 255 charachters and I
>use UNICODE_FSS characterset.
>Now to my problem:
>After I´ve changed a SP or did something else in the DB with
>Firebird-Workbench or EMS Firebird Manager the length of my VARCHAR and CHAR
>Parameters is changing itself!!! E.g NAME VARCHAR(200) gets to NAME
>VARCHAR(765) after I commit the changes to the SP. This stops only when
>Firebird says: '...implementation limit exceded...' and my Parameter have a
>length of about 3000 charachters!!!!!.

UNICODE_FSS has three-byte characters. A varchar(200) will have a length
of 600 bytes. A varchar(255) will have a length of 765 bytes. Are you
sure your tools are not showing you the byte length, rather than the number
of characters?

>What´s going on? Is this a bug or a wrong DB Design on my side? Are the SP
>Parameter limited?

Exactly what change did you do to the parameter that is being reported with
a length of 3000?

If you have an index on a unicode column, both 200 and 255 would be well in
excess of the implementation limit (which will be about 65 characters,
perhaps less, if you have a collation order defined). Did you change the
column sizes of any indexed columns in the same script?