As to the discussion about char vs. varchar fields, I am now into a problem
which is near by the above one:
We are about to design a new database with high importance to stability and crash
recovery. So I found, that two types of MyISAM tables exist (static and dynamic).
If you have only fixed
, 2004 10:01 AM
Subject: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion
from `char` TO `varchar`)
As to the discussion about char vs. varchar fields, I am now into a problem
which is near by the above one:
We are about to design a new database with high importance to stability
OK, this will be my last post on this topic. Mainly I want
to point out that I was taking the wrong conclusions from
the results of my tests. I followed the advice of Michael
Stassen and ran some more tests using int columns for joins
and got pretty much the same trend. So I guess the real
answer
10, 2004 7:06 AM
Subject: Automatic conversion from `char` TO `varchar`
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
the auto-conversion of CHAR to VARCHAR ?
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 7:06 AM
Subject: Automatic conversion from `char` TO `varchar`
Hi,
It's really strange but when I execute
-conversion of CHAR to VARCHAR ?
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 7:06 AM
Subject: Automatic conversion from `char` TO `varchar`
Hi,
It's really strange but when I execute
Hi Michael,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types this is
okay,
and
Hi,
- Original Message -
From: Michael Stassen
Sent: Sunday, January 11, 2004 5:10 PM
Subject: Re: Automatic conversion from `char` TO `varchar`
Martijn Tonies wrote:
Hi,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known
Martijn Tonies wrote:
Hi Michael,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types
Hi Michael,
Indeed. Nevertheless, I'm right at this one :-)
I defer to your expertise on SQL standards. Regardless of the standard,
however, mysql does not pad CHARs with spaces. Thus, CHARs and VARCHARs
are identical from the client's point of view, so silently changing
CHARs to
you seem to have mixed single and double quotes.
this might be your problem
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 7:06 AM
Subject: Automatic conversion from `char` TO `varchar`
Hi,
It's
Martijn Tonies wrote:
Hi,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types this is
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.
CREATE TABLE `offer` (
`SVID` int(11) NOT NULL
No, it´s not strange.
Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html
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
On Sat, Jan 10, 2004 at 05:06:56PM +0500, Hassan Shaikh wrote:
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.
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
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types this is okay,
and may be regarded as a
Hi,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types this is okay,
and may
18 matches
Mail list logo