You are expecting an awfull lot from mysql to remember data that it never
recorded. When you inserted something into the varchar(50) column that was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
> I had a column that was set to varchar(50) which ended up not being enough
> space. So I went in and did a:
> alter table main change description description varchar(255) not null;
> It said everything went ok, I reimported the text file, but the words stop
> after 50 characters still did I miss something or do I have to totally
> delete the column and readd it????
>
> Thanks,
> Scott
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
