| Subject | Re: [firebird-support] How can I change a blob column to varchar? |
|---|---|
| Author | James N Hitz |
| Post date | 2008-02-12T14:42:50Z |
mlq97 wrote:
2. then..
UPDATE tableName SET varCol =
(SELECT SUBSTRING(blobCol FROM 1 FOR 500) from tableName)
3. dont forget:
COMMIT
4. delete BLOB field
5. rename VARCHAR field
> I have a blob column that contains only text data. I would like to1. create the VARCHAR(500) field
> change the column type to varchar(500). Is this possible? How can I do
> this?
>
>
2. then..
UPDATE tableName SET varCol =
(SELECT SUBSTRING(blobCol FROM 1 FOR 500) from tableName)
3. dont forget:
COMMIT
4. delete BLOB field
5. rename VARCHAR field
> Mitch
>