List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 4 2002 6:24pm
Subject:Re: VARCHAR/CHAR problem
View as plain text  
At 15:39 +0200 3/4/02, savaidis wrote:
>I give this query:
>
>ALTER TABLE `companies` ADD `Tel3` CHAR(30)  BINARY
>
>but it creates tel3 as VARCHAR(30) !

You have other variable-length columns in your table.

http://www.mysql.com/doc/S/i/Silent_column_changes.html

>
>Why?
>
>Makis

Thread
buggy round()Roger Baklund1 Mar
  • Re: buggy round()Benjamin Pflugmann1 Mar
    • RE: buggy round()Roger Baklund1 Mar
      • Re: buggy round()Benjamin Pflugmann1 Mar
        • RE: buggy round()Roger Baklund2 Mar
          • Re: buggy round()Shankar Unni2 Mar
        • Inconsistency in the documentationRoger Baklund2 Mar
          • RE: Inconsistency in the documentationRoger Baklund3 Mar
        • RE: buggy round()Gordon3 Mar
          • RE: buggy round()Roger Baklund3 Mar
            • RE: buggy round()Sommai Fongnamthip4 Mar
  • Re: buggy round()BD4 Mar
Re: Inconsistency in the documentationRoger Baklund2 Mar
RE: Inconsistency in the documentationDoug Thompson3 Mar
  • documentation about the various databasessavaidis3 Mar
    • Commands...Stephane Collas3 Mar
      • RE: Commands...Roger Baklund3 Mar
        • Re: Commands...Stephane Collas3 Mar
          • RE: Commands...Todd Williamsen3 Mar
    • RE: documentation about the various databasesRoger Baklund3 Mar
      • RE: documentation about the various databasessavaidis4 Mar
        • VARCHAR/CHAR problemsavaidis4 Mar
          • Re: VARCHAR/CHAR problemPaul DuBois4 Mar