| Subject | Re: [firebird-support] How To Change Column DataType From Varchar To Integer ? |
|---|---|
| Author | Vishal Tiwari |
| Post date | 2015-04-22T11:41:11Z |
If I make all values to null of that column which is of type varchar and then go for Alter, would you share the sql for it ?
On Wednesday, 22 April 2015 3:10 PM, "Mark Rotteveel mark@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
On Wed, 22 Apr 2015 09:00:18 +0000 (UTC), "Vishal Tiwari
vishualsoft@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
There is, but it doesn't support conversion from (VAR)CHAR to INTEGER. The
conversion isn't done at ALTER time, but when the field is queried or
updated. This means that Firebird cannot ensure that current values are
convertible to INTEGER, and therefor the conversion is not allowed.
Mark
vishualsoft@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
> Is there no Alter like SQL available ?
There is, but it doesn't support conversion from (VAR)CHAR to INTEGER. The
conversion isn't done at ALTER time, but when the field is queried or
updated. This means that Firebird cannot ensure that current values are
convertible to INTEGER, and therefor the conversion is not allowed.
Mark