I think that is absolutely a bad idea. Not only are you splitting data
that should logically be together, you will need to add three indexes
and perform three searched to get at the data. You typical index only
indexes from the start of the field, so even if you split the data, you
can't do con
nks,
Scott
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, May 23, 2005 8:58 AM
To: Brent Baisley
Cc: Scott Purcell; mysql@lists.mysql.com
Subject: Re: varchar to text
Hi,
I we can, one should ask if it is a good solution ?
text can't be indexed as a varchar
TED]>:
> You can safely change varchar to text, since they are the same data
> type.
>
> ALTER TABLE table_name CHANGE field_name field_name TEXT
>
> But, as always, make sure you have a recent backup. There is always the
> possibility that your computer will crash in the m
You can safely change varchar to text, since they are the same data
type.
ALTER TABLE table_name CHANGE field_name field_name TEXT
But, as always, make sure you have a recent backup. There is always the
possibility that your computer will crash in the middle of the
operation due to a stray
me` text
default null
J.R.
-Original Message-
From: Scott Purcell [mailto:[EMAIL PROTECTED]
Sent: Monday, May 23, 2005 9:37 AM
To: mysql@lists.mysql.com
Subject: varchar to text
Hello,
I created a table that uses a varchar(254) size field, and found out that
the customers data is being trunc
Hello,
I created a table that uses a varchar(254) size field, and found out that the
customers data is being truncated. It needs to be larger.
Currently there are about 500 records (it is a description field) in the
column. Upon reading the docs, it looks like I need to use a "text" type column.
