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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
