Subject | Re: [ib-support] Default database collation |
---|---|
Author | Achim Kalwa |
Post date | 2002-05-13T10:10:43Z |
Hello Helen,
I just ran into problems by adding a new varchar-field to an existing
table: "alter table AUFTRAG add E_USER varchar(30)"
The new field has no character set defined. So what is the default
character set for?
Achim
> At 06:39 AM 10-05-02 +0000, you wrote:is this different behaviour from Interbase 6.0?
> >Default collation for default char set WIN1250 for database is
> >WIN1250 collation.
> >But I need created database with default char set WIN1250 and default
> >collation PXW_CSY.
> >It is possible?
> >Thanks for any advise.
>
> No. You need to specify the collation order when declaring domains and/or
> columns. You can also specify the collation order in a GROUP BY clause.
I just ran into problems by adding a new varchar-field to an existing
table: "alter table AUFTRAG add E_USER varchar(30)"
The new field has no character set defined. So what is the default
character set for?
Achim