Re: [Firebird-devel] unsuccessful metadata update...

[Martijn T. <m.t...@up...>]

Hi,

I believe Claudio once said that you should/could write:

ALTER TABLE LICENSES
   ALTER DESCRIPTION TYPE VarChar(50) characterset ISO8859_1

But I also believe it was decided that if no charset was specified in the
ALTER statement, it would assume the current charset.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Another unsuccessful metadata update issue :
> I hope this is reproducable for others.
>
>
> Create DATABASE, page size 4096, characterset ISO8859_1
>
>
> CREATE TABLE LICENSES (
>   ID CHAR(8) NOT NULL PRIMARY KEY,
>   DESCRIPTION VARCHAR(30)
> )
>
> Try to alter the column DESCRIPTION :
>
> ALTER TABLE LICENSES
>   ALTER DESCRIPTION TYPE VarChar(50)
>
> Error result :
> unsuccessful metadata update New size specified for column DESCRIPTION
must
> be at least 30 characters.