Jump to content

Archived

This topic is now archived and is closed to further replies.

djmonkey1

How to set character length when adding a new field to the database

Recommended Posts

I've got the following sql query:

 

INSERT INTO configuration SET configuration_title='Set "Contact Us" Email List', date_added=NOW(), sort_order='11', configuration_group_id='1', configuration_key='CONTACT_US_LIST', configuration_value= '', configuration_description='On the "Contact Us" Page, set the list of email addresses , in this format: Name 1 <email@address1>, Name 2 <email@address2>', use_function = NULL , set_function = NULL;

 

But the value of the corresponding text box that's created is too small, only 255 characters. How should this sql query be written to change this? I want to have a text field of unlimited length.

 

Thanks

Stew


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites
It is not the query you need to change but the data type in the database for that field.

 

http://dev.mysql.com/tech-resources/articl...-datatypes.html

 

I don't see an option to do that from within my database manager.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites

×