MySQL Forums
Forum List  »  Knowledge Base

ALter table
Posted by: sagazona desouza
Date: November 16, 2008 06:28PM

Hi Mysql team,

I recently wanted to increase the size of a field of a table. I used the
ALTER TABLE emails CHANGE Username Username CHAR(30); to store more than 8 chars.
Originally the Username field was CHAR(8).

The result was that it did store more than 8 characters but everything after the 8th character was random characters/garbarage, nothing similar to the data entered.

Pls tell me if there is something I missed in the procedure.

thank u very much.
best regards,

Options: ReplyQuote

Written By
ALter table
November 16, 2008 06:28PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.