List:General Discussion« Previous MessageNext Message »
From:<programmer Date:March 18 2004 10:00am
Subject:COLLATE in CREATE TABLE
View as plain text  
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, what does DEFAULT before CHARACTER SET means?

If I don't use SHOW TABLE STATUS but SHOW CREATE TABLE the result is
interesting too.
For the table I applied the DEFAULT keyword the generated CREATE
TABLE-statement uses the DEFAULT keyword too, but does not show the
COLLATE part of the CREATE TABLE statement.
For the table I omited the DEFAULT keyword, the generated
CREATE-statement uses the DEFAULT keyword - though omited in my
statement -, and shows the COLLATE part of the CREATE TABLE statement.
It's in fact my first statement.....

Is this regular behaviour?

I'm running MySQL 4.1.1a on an NT4-Box

Best wishes,
Bernhard
Thread
COLLATE in CREATE TABLEprogrammer18 Mar
  • Re: COLLATE in CREATE TABLEVictoria Reznichenko22 Mar