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

[Leigh Wanstead]

Hi Phil,

How about create a new temp table with VarChar(20) and write a delphi
utility application to copy everything to that table? Once data in that temp
table, you may drop original one and recreate original one.

Regards
Leigh
www.smootharm.com

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz
[mailto:delphi-bounces at ns3.123.co.nz]On Behalf Of Phil Middlemiss
Sent: Monday, 8 May 2006 1:59 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] Change a VarChar(255) into a VarChar(20) - Firebird


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.