[DUG] Change a VarChar(255) into a VarChar(20) - Firebird

[Rohit Gupta]

Thats the way it is.  You get around it by creating a new field, copy 
the data, delete the old one

Phil Middlemiss wrote:
> I have an Firebird database with a field that stores a small string 
> value in a VarChar(255). I want to change that now to a VarChar(20) 
> which is plenty big enough so that I can create an index on it. But of 
> course, Firebird won't let me reduce the varchar size since it is 
> already populated (although no values over 20 chars long).
>
> Any ideas?
>
> Cheers,
> Phil.
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>