[EMAIL PROTECTED] wrote:
>
> I want to CREATE a TABLE an specify a collation.
>
> If I do
> CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
> SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
> If I omit the keyword DEFAULT the requested collation latin1_german1_ci
Hi,
I want to CREATE a TABLE an specify a collation.
If I do
CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
If I omit the keyword DEFAULT the requested collation latin1_german1_ci
is shown by SHOW TABLE STATUS.
So
