Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Sep 2003
    Posts
    84
    Member #
    2930
    Hi guys. Im pretty new to mysql and i have a news update and shoutbox on my website but the trouble is the max amount of charaters the fields will accept in varchar is 255, and when someone does a post or i make a long news article it cutss off after 255 chars for obvious reasons.

    I just want to know the code to extend that number to anything.

  2.  

  3. #2
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    This the mysql query you need to run to change that field:

    Code:
    ALTER TABLE TABLE_NAME CHANGE `FIELD_NAME` `FIELD_NAME` TEXT
    Of course, change "TABLE_NAME" and "FIELD_NAME" appropriatly.
    There and Back Again :Ogre:


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:27 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com