On 04/01/11 11:47, Dmitry Yemanov wrote:
> 01.04.2011 11:19, Kjell Rilbe wrote:
>
>> I'm not sure I made much sense... Tell me, does the standard specify
>> anything regarding datatype change features? If so, what does it say?
> It allows to alter a string column to a string one of the non-shorter
> length. This is how FB works since the beginning. I cannot find any
> reference to charset/collation details, unfortunately.
>
Dmitry, where have you found a reference in standard tat string column
can be altered to wider one type?
What Is see in SQL2008 is:
11.12 <alter column definition>
Function
Change a column and its definition.
Format
<alter column definition> ::=
ALTER [ COLUMN ] <column name> <alter column action>
<alter column action> ::=
<set column default clause>
| <drop column default clause>
| <add column scope clause>
| <drop column scope clause>
| <alter identity column specification>
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
