List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:June 23 1999 4:04pm
Subject:Re: Strange problem with CREATE TABLE
View as plain text  
On Mi, 1999-06-23 08:48:42 -0700, Ying Zhang wrote:
> I'm experiencing a strange problem with my CREATE TABLE statements,
> whenever I create columns with CHAR types, they turn into VARCHAR types:
[...]
> mysql> CREATE TABLE sessions (
>     ->   id char(10) DEFAULT '' NOT NULL,
>     ->   session_data text,
>     ->   PRIMARY KEY (id)
>     -> );

The MySQL manual is quite good!

Chapter 7.6.1 talks about "Silent column specification changes".

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Strange problem with CREATE TABLEYing Zhang23 Jun
  • Re: Strange problem with CREATE TABLEMartin Ramsch23 Jun