subject:"COLLATE in CREATE TABLE"

Re: COLLATE in CREATE TABLE

2004-03-22 Thread Victoria Reznichenko

[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 is

COLLATE in CREATE TABLE

2004-03-18 Thread programmer

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.