Subject Re: [firebird-support] About BLOB fields.
Author Alexandre Benson Smith
William Gonzáles S. wrote:
> Hello. I have a string column, the minumun length is
> 18 but the max is no defined, it could be 50, 100,
> 500, .., the data type is BLOB (string) with length
> 50, but if the text is greater to 50, FB gives an
> error and the registry is not updated. Is it possible
> to create a string column with undefined length?
> Thanks in advance,
> William GS

Hi William,

What's the datatype used ? Varchar or Blob ???

On Blob you don't define the max length you define the segment size
(that is another beast) on ly on char/varchar you define the max length.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil