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

[Phil Middlemiss]

Fair enough. Just wondered if there was a tool already out there that 
did it. As it turns out, some of the data in there is over 20chars long 
now anyway so I will have to do a little bit of hand massaging.

Phil.

Rohit Gupta wrote:
> 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
>>   
>
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phil.vcf
Type: text/x-vcard
Size: 250 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060508/212d56ea/phil.vcf