Subject Re: [ib-support] Default database collation
Author Achim Kalwa
Hello Helen,

> At 06:39 AM 10-05-02 +0000, you wrote:
> >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.

is this different behaviour from Interbase 6.0?

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