Subject RE: [firebird-support] Changing field size to smaller
Author Johan van Zyl
We in the Clarion world can buy a 3rd party tool called File Manager 3
( that will do it (Changing field size to smaller)
for us, without any problems. It should cater for Firebird very soon,
already works for MS SQL, MySQL etc.
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 10 August 2004 12:58
Subject: Re: [firebird-support] Changing field size to smaller


> I want to write SQL script for database modification.
> Can someone tell me is it possible to change existing varchar(200) field
> into varchar(150) when the table contains data longer than 150 symbols.
> Currently I get truncation error when trying to update data from longer
> field to shorter.

The only way to do this is to create a new column,
move the data and drop the old column.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
Upscene Productions

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.736 / Virus Database: 490 - Release Date: 2004/08/09

[Non-text portions of this message have been removed]