From: Martijn Tonies
Date: January 10 2004 3:06pm
Subject: Re: Automatic conversion from `char` TO `varchar`
List-Archive: http://lists.mysql.com/mysql/157360
Message-Id: <014601c3d78b$619226e0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi,

> No, it´s not strange.
> Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html

Yes, it's documented. But it still is strage.

CHAR should, according to the SQL specification, pad any value
smaller than the defined number of characters with spaces when
it returns the value to the client. VARCHAR doesn't.

So yes, it's strange. But you just have to live with it. I guess.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


> Best Regards
> ---
> Luciano Barcaro
> Depto. Informática - Laboratório Alvaro
>
> Hassan Shaikh wrote:
>
> >Hi,
> >
> >It's really strange but when I execute the following statement, all my
char(10) columns turn into varchar(10). My other tables are ok and I've
tried create dummy table also. Problem seems to be associated with this
table only.
> >