[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 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
Thank you for report! Entered to the bug database as bug #3255:
http://bugs.mysql.com/bug.php?id=3255
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
