MySQL will automatically change it to a VARCHAR even if you try to set
it as a CHAR. Whether you like it or not.
Jordan Sparks
-----Original Message-----
From: Patrick Questembert [mailto:patrickq@stripped]
Sent: Monday, December 20, 2004 12:53 PM
To: dotnet@stripped
Subject: VACHAR and performance
Hi all,
If I have a text field holding a name between 8 and 32 chars, would it
hurt performance if I defined it as VACHAR (as opposed to fixed size at
32)? Would the answer to this question depend on:
- whether or not I have an index defined for this column (I think I will
define an index for it)
- whether I have another VACHAR column for that row in any case (I do),
on the grounds that if one column in the table is of variable length,
then the total row size is variable anyhow, and performance will not
suffer from yet another variable-length column
Thanks!
Patrick
--
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
