Namor,
As Paul said we can make a guess, but more information would be
necessary. I would first try looking at this page:
http://www.mysql.com/doc/en/Silent_column_changes.html
In short, the following could be the cause as to why your columns are
being changed:
<quote>
* If any column in a table has a variable length, the entire row is
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns
longer than three characters are changed to VARCHAR columns. This
doesn't affect how you use the columns in any way; in MySQL, VARCHAR is
just a different way to store characters. MySQL performs this conversion
because it saves space and makes table operations faster. See section 7
MySQL Table Types.
</quote>
Also, if your table already exists and you are performing 'ALTER TABLE'
commands, please look at the following:
http://www.mysql.com/doc/en/ALTER_TABLE.html
In short, this gives the following information
<quote>
If you use ALTER TABLE to change a column specification but DESCRIBE
tbl_name indicates that your column was not changed, it is possible that
MySQL ignored your modification for one of the reasons described in
section 6.5.3.1 Silent Column Specification Changes. For example, if you
try to change a VARCHAR column to CHAR, MySQL will still use VARCHAR if
the table contains other variable-length columns.
</quote>
Again, most likely we will need to see more information to correctly
identify the purpose, but hopefully this information will guide you in
the right direction.
Thanks,
Ryan Yagatich
On Sun, 2003-06-22 at 12:40, Namor Taror wrote:
> I just created a table with some char columns (I am using Control Center).
> Every time I save the table (during the design process) my char fields are
> reset to varchar. Does anybody know why?
>
> Ron
>
> _________________________________________________________________
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
--
,_____________________________________________________,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http://www.pantek.com/security (440) 519-1802 \
/ Are your networks secure? Are you certain? /
\___A9062F5C3EAE81D54A28A8C1289943D9EE43015BD8BC03F1___\
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
